I have a pivot table with 3 expressions budget, spend and difference. difference being spend-budget.
There are plans such that budget is allocated, but spend data is not available. Now I want the chart to be displayed in such a way that, if the spend data is not available, do not show the spend and difference.
That means for Plan3, I will only see budget column and not spend and difference. How do I achieve that.