Getting Total Sales In Impromptu 1

[MitraMIS]

I have selected some specific customers in my report to get the total sales. How can I have The total row at the end to give me tht total for all other customers except the ones that is listed in the report.
Report is crosstab report.

Customer Name Past Due Current Week Future
A
B
C
Total(All customers except A,B,C)

TIA
Mitra

 

[griffindm]

Mitra,

The best way to do this is to NOT filter the report by customer. You can either simple HIDE those customers for which you wish to suppress the display (the report totals will reflect the hidden data), or you can force the customer number for all those other than your selected display set into an 'OTHER' group, and just show them as an additional amount in the report.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[MitraMIS]

Dave, Thanks for the tip. It worked.

I got all the records and HIDE the ones that I don't want to show.

Mitra