Hello
I would like to hide columns in cross-tab. I used suppress with formula but it leaves empty columns.
The current cross tab is like this
07/01/2020 07/02/20 07/03/20 07/04/20 07/05/20 Total
Site 1 1 1 2 3 2 9
Site 2 3 2 2 3 2 12
Site 3 1 3 2 3 2 11
The desired output is
07/04/20 07/05/20 Total
Site 1 3 2 9
Site 2 3 2 12
Site 3 3 2 11
I want to hide columns that are less than a certain date but still use them to calculate the total. Only show last two days count and total. The total should be the sum of all dates available.
Thanks
I would like to hide columns in cross-tab. I used suppress with formula but it leaves empty columns.
The current cross tab is like this
07/01/2020 07/02/20 07/03/20 07/04/20 07/05/20 Total
Site 1 1 1 2 3 2 9
Site 2 3 2 2 3 2 12
Site 3 1 3 2 3 2 11
The desired output is
07/04/20 07/05/20 Total
Site 1 3 2 9
Site 2 3 2 12
Site 3 3 2 11
I want to hide columns that are less than a certain date but still use them to calculate the total. Only show last two days count and total. The total should be the sum of all dates available.
Thanks