cancel
Showing results for 
Search instead for 
Did you mean: 

Possible to hide but not supress Crosstab column totals?

Former Member
0 Kudos

The reason I ask is because I really don't want to show the whole crosstab column totals section.

Only reason I need the column totals of a crosstab is because I am taking some field values off of it by defining variables using a supression formula.

I then take the variable and make a calculation on the crosstab itself... just not on the column totals.

So simply put,

Any way to 'hide' column totals in Crosstabs? Supressing it in Cross-tab Expert would render my declared variables to zero.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member292966
Active Contributor
0 Kudos

Hi Eric,

The only way I can think of doing this would be to use a parameter in the Record Selection Formula or in the Column formula and say something like:

{Table.FIELD1} <> {?ExludeParam};

If you can dynamically exclude the column you don't want then it won't show in the cross tab.

Hope this helps,

Brian

Former Member
0 Kudos

Hi Brian.

Unfortunately, the column that would-be hidden using your method would also be something I need to show in the actual Crosstab summary calculations.

Ultimate goal is to show all the summary calculations but just hide the "Column Totals" which also has a supression formula declared in order to use that variable in a display string within a Crosstab summary field.

A bit complicated without showing the Crosstab but that's the best way I can explain it I guess.

Former Member
0 Kudos

i know you can hightlight the totals in the row under the custom tab in the cross tab and select surpress, that may do it, otherwise i have click on the field, formated field, surpress, it makes the layout a bit off, but it worked for me.

Former Member
0 Kudos

Thanks all. Found a workaround (not pretty but it works for now) by whiting-out a bunch of total fields and making them smallest possible.