CrossTab Column Totals problem

[skurkal]

Hi All,

I have a crosstab which looks like this :

01/22 01/23 01/24 01/25 01/26
HR1 2 3 4 1 0
HR2 1 5 0 2 0
Totals 77 85 92 106 28 (The total inclues the suppressed "others" column)



I have used a formula to get the row values, which shows only HR1 and HR2 values and then groups everthing else in "Others". Then I used BottomN to show only HR1 and HR2 values on the crosstab and not "Others". Which is how I want it. But the problem is that the column totals shows everything instead of just the sum of HR1 and HR2. I want the above crosstab to look like this :

01/22 01/23 01/24 01/25 01/26
HR1 2 3 4 1 0
HR2 1 5 0 2 0
Totals 3 8 4 3 0

I cannot discard "Others" because that is the only way 0 values shows up in my cross tab.

Any help will be appreciated,
Skurkal

 

[lbass]

Instead of your current summary field, create a formula like:

if {table.field} in ["HR1","HR2"] then {table.amt}

Use this instead of your current summary.

-LB

 

[skurkal]

Thanks for the push in the right direction. I thing I was unnecessarily complicating matters.