on 08-19-2008 4:45 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.