Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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
Thanks a lot SKG !
It works..
Glad I could help. Remember to mark the correct answer as such to help others with the same problem.
Regards
SKG
Use this:
=Sum({<DimA={'*'}-{a1}>}c)
Regards
Aviral Nag