Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Is it possible to show empty row filter value in a pivot table. For example I don't want to show value's flashing in CDG row i.e. {A,B,C} when I select the CDG filter in the pivot.
Except for filter it should flash in the pivot
Can u rephrase that please? I tried to uderstand the point u're making..but I'm not that sure !
Hi Omar,
I want that whenever I select the CDG filter in row of a pivot it should not show me any option. Is that possible?
In different words; you want to always have all the CDG values in your table and thus eliminate the possibility of filring by CDG column?
Since ur demand is not possible; u can alter ur measure by including {<CDG>}
example:
sum({<CDG>}Sales) : with that, even when u select a CDG's value; it won't affect ur pivot table, and every CDG will still be in the table