Hide column in Cross tab - CR2013

[pndMaster]

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

 

[SkipVought]

@ pndMaster,
In order to display your tabular data in a meaningful way, you need to use TGML tag set [ignore][pre]…[/pre][/ignore] like...

[pre]
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
[/pre]
...which often includes lots of meticulous space padding. Might take you 5 or 10 minutes to get a decent understandable example.

FYI, [ignore][pre]…[/pre][/ignore] & [ignore][tt]…[/tt][/ignore] each display in a fixed pitch font while only [ignore][pre]…[/pre][/ignore] allows SPACE padding. The normal posting font on this site is a proportional spaced font, which in not suitable for displaying tabular examples.
Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein