Showing more dimension values than those selected in chart with set analysis

[#1]

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

[Anonymous]

try

aggr(only({1<Field1=>}Field1),Field1)

[tresesco]

Instead use Set in the expression of the chart, like:

Dim: Field1

Expression: Sum({1} Amount)

[jonathandienst]

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