Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a chart (pivot table) in which I'd like some of the dimensions to list values beyond those selected.
I tried using a calculated dimension with SA expression such as:
Aggr(Only({1}Field1),Field1)
to show all values, but I get only the selected values in Field1.
Could anyone help please?
Thanks!
-Michal
try
aggr(only({1<Field1=>}Field1),Field1)
Instead use Set in the expression of the chart, like:
Dim: Field1
Expression: Sum({1} Amount)
Hi
Have you turned on Suppress Zeroes and Suppress Nulls? If these are on it is likely that the expressions are returning null for the non-selected Field1 values and are being suppressed.
Turn off the suppression or add a Field1 selection override to all the expressions in the chart.
HTH
Jonathan