Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Basically I want to hide the expression column if the values are null.
Did you already found a solution for this? Looking at the same problem