Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TopN with "Others" not working as expected.

Status
Not open for further replies.
tkaz

tkaz

Technical User
Feb 21, 2005
75
US
I am using SQL Server 2008 and CR XI.

I have a crosstab report that includes plant, prodid, proddesc, custid, custname,matlunits, dollars, and a calculated field - ASP.

I want to sort in descending order by prodid based on the sum of the matlunits. Done...
I then want to pick the TopN 5 based on custid...I can get that to work, but I want to include "Others" as one group that would summarize the remainder of the customers units and dollars. I am not seeing the "Others" group even though the box is checked and I've included ties. Can someone tell me what I might be doing wrong?

Thanks!
 
Status
Not open for further replies.

Similar threads

Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
267
lbass
lbass
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
594
dgillz
dgillz
john432
  • Locked
  • Question
Crystal Report formula (finding with key words) 1
Replies
2
Views
276
john432
john432
sjill
  • Locked
  • Question
Crystal Reports - Sub Report behaving as a hyperlink
Replies
4
Views
251
kray4660
kray4660
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
127
BradCustom
BradCustom

Part and Inventory Search

Sponsor

Back
Top