I have a pivot table to show the profit and loss account and for income and cost I have a cascade totals which work fine when I only show the lines with values but I need to show some other lines for cost and income which have no values but they are part of our P&L. When I go to the pivot table option- Display and then tick the box "Show items with no data in row" the cascade totals of income and cost disappear. Has anyone had such a problem before and can help me?

Hi Pmorris123,

Did you manage to resolve this issue? If not have you already tried creating versions of your measures that have a '0' added to the result to force blank values to appear as '0'?

For example:

NewCostMeasure := [ExistingCostMeasure] + 0