Hiding a Column in a pivot

[#1]

Hi,

I have two Dimensions - (a) DimA, and (b) DimB across which I want to show SUM(c).....DimA has 4 possible values - a1,a2,a3 and a4.

In my pivot table, I dont want to display SUM(c) for value a1 of DimA.

Does anybody has any idea about it ?

[simenkg · Accepted solution]

you use the expression Sum({$<DimA-={'a1'}>}c)

It will give you a syntax error (Red underline) but will work non the less.

If you prefer to not get syntax errors you can use:

sum({$<DimA={'a2','a3','a4'}>}c)

Regards

SKG

[#3]

Thanks a lot SKG !

It works..

[simenkg]

Glad I could help. Remember to mark the correct answer as such to help others with the same problem.

Regards
SKG

[aveeeeeee7en]

Use this:

=Sum({<DimA={'*'}-{a1}>}c)

Regards

Aviral Nag