Can i restrict showing all the values in a pivot row filter

[siddharthsoam]

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

[OmarBenSalem]

Can u rephrase that please? I tried to uderstand the point u're making..but I'm not that sure !

[siddharthsoam]

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?

[OmarBenSalem]

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