Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Year and Quarter Dimensions in my Pivot table. My Measure values should calculate as explained below. When i select Year dimension, the Pivot Total should only consider Q4 values. Q1, Q2 and Q3 can have the actual values but they should not be part of Total calculation. Guide me how to solve this issue.
Expected result attached.
If(Dimensionality()=0,Sum({<Quarter={'Q4'}>}Sales),Sum(Sales))
Thanks for the quick reply.
The above solution partially solved my problem. The Totals are tking only Q4 value. But when it is aggregated at only Year level, even i want to show only Q4 Sales in stead of Sum(Sales) for Year. How can i acheive that?
If you only want to show Q4 values then use Sum({<Quarter={'Q4'}>}Sales)
when quarter dimension is added, i want to show all, but for year dimension, only Q4.
Changed like this....working fine
If
(Dimensionality()=1 or Dimensionality()=2,Sum({<Quarter={'Q4'}>}Sales),Sum(Sales))