Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
sujit_nath
Creator III
Creator III

Hide columns in pivot table

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.

Capture.PNG

That means for Plan3, I will only see budget column and not spend and difference. How do I achieve that.

Labels (1)
2 Replies
sujit_nath
Creator III
Creator III
Author

Basically I want to hide the expression column if the values are null.

jj_kobalt
Contributor
Contributor

Did you already found a solution for this? Looking at the same problem