Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hide column in Cross tab - CR2013

Status
Not open for further replies.

pndMaster

IS-IT--Management
Mar 6, 2013
20
US
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
 
@ 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]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top