Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Build a pivot table samething like below
Month Month1 Month2 Total
dimension
A 10 20 30
B 20 30 50
C 30 40 70
is when i have no selection on filter "dimension".
and shows respective A, B, C values when a value is selected in filter.
Here when no filter is selected,
I want My table look like
Month Month1 Month2 Total
dimension
ALL 60 90 160
Please help.
May be use a calculated dimension like this
If(GetSelectedCount(Dimension) = 0, 'ALL', Dimension)
May be use a calculated dimension like this
If(GetSelectedCount(Dimension) = 0, 'ALL', Dimension)