When adding a difference calculation value to a pivot table (in my case showing changes Month-over-Month), the first instance of the column is empty because the difference is by definition zero. This uses unnecessary space. It would seem best to hide these by default.
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Difference Pivot Table Empty Cell | 2 | 601 | July 16, 2024 | |
Hide first calculated column that is blank in a pivot table | 4 | 807 | May 16, 2023 | |
Using Pivot Table Differences with Zero Values | 4 | 206 | March 4, 2024 | |
Comparison of data with table calculation in value | 6 | 28 | December 12, 2024 | |
Hide the first column in a month-over-month calculation | 5 | 123 | July 3, 2024 |