Absolute reference to hidden row in special calculations
My calculation
sum(0, @"[P&L].[Resultat før skat].[10400: Turnover service items]"(l(3)), m1)
does not work when my hierarchy is collapsed. Is it possible to modify the fomula to find the value when hidden in a collapsed hierachy in any way?
0
Hi Jonas,
TARGIT client based calculations generally require data, upon which they are based, to be present in the object.
Hiding values with visibility settings or with visibility agents are ok - values will still be available for calculations.
But collapsing a hierarchy will perform a new data query, and data on the collapsed levels will no longer be available for calculations.
BR / Ole
Hi Ole,
That requires we work around with a hidden user dimension for that specific calculation, I suppose?
Regards,
Jonas