not sure you understod the problem.
look at the pictures, when i expand the table i want the calculated rows/cells to show grey, like in HM, UM and DIFF.
DIFF HM-UM, AVVIK HM, AVVIK UM are calculated rows.
If it is a straight table you can conditionally hide the column or if you want only the values in the column not to show then make the font and background color same conditionally
For the first , goto presentation tab
and for the second one goto the visual cues or + (background) in the expression tab
thank you for reply, but that not solved the problem..
When i expand the pivot table it gets messi, all the calculated rows.
I have grey'd out the cells with no value in it, i want the same for the calculated cells when the pivot table are expanded.
When the pivot table is collapsed it shows the right calculation and colour.