Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table, which calculates a number of expressions, and performs different calculations depending on the Key Performance Indicator that the pivot table is grouping by. It works fine, but one of the dimensions that I want to add to the table surrounds the cost area for the P&L the table concentrates on... there are a lot of these and I only want the table to show a row if the cost area has a value. At the minute it is showing all the rows that have zero values.
Expanded
My question is how can i suppress the rows where the expression values are zero. I'm guessing I need a calculated dimension, i've tried onel along the lines of: IF([Actual] <> 0, [GL Group]) but with little success. Can anyone point me in the right direction?
Thanks,
Matt
Hi Matt.
Try this....
In your Pivot Table, select in a sheet "Dimensions" the option "Supress when Values is null' for all fields, and in a sheet "Expressions" alter the calculation for:
If(
[your calculation]<>0,
[your calculation],
null()
)
Regards.