Hiding the total value in pivot table

[#1]

Hi All,

I have a cyclic group as a dimension (Year,Quarter and Month) and the corresponding sales as a expression.

I have only one year data...So I want to supress "Total" value for the Year dimension alone. if the user changes the dimension from Year then "Total" value should be displayed.

Is it possible to achieve in Pivot table?

[Anonymous]

Yes, it is possible.
First, use condition GetCurrentField(CycleGroupName)='Year'.
Next, use dimensionality()=0.
So, if the expression is sum(Amount), change it to:
if(GetCurrentField(CycleGroupName)='Year' AND dimensionality()=0, null(), sum(Amount))