How to omit the particular row in Crosstab report in Sum column

[rajkumarmj]

Consider the following Examples
Region Quarter1 Quarter2 Quarter3 Quarter4
South 1000 100 200 300
North 1500 200 300 200
West 500 200 100 100
East 1000 500 400 400
Other 500 100 200 300 <- Ignore row

Total 3000 1000 1000 1000

I want to ignore the Other row in Total

Thanks in advance

 

[resdevlabs]

Can you not use the SQL Expert to exclude this data.

I.E. - Region <> &quot;Other&quot;

RES

 

[lbass]

You could either exclude those locations that fall into the &quot;Other&quot; category in your record select, or if you are using specified groups to define your groups within the crosstab, in the &quot;other&quot; tab, choose &quot;discard all others.&quot;

If you want to display the &quot;Other&quot; row, but just not have it contribute to the total, then you'll probably have to do a manual crosstab and use a running total which evaluates based on a formula that excludes records in the &quot;Other&quot; category. I think that would be a confusing display though.

-LB