If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to create a summary query from detail query

Started by Tsunami, 22 Sep 2011 11:15:08 AM

Previous topic - Next topic

Tsunami

I have a detail query that pulls one salesperson, their customers and their sales for the month.  Now I want to add a summary page that has a list of all salespeople and the total for the month.

I tried creating a second query and postioned the detailed query just to the right of it.  I then only pulled the 'salesperson', and 'total(month)' data items.  This isn't working for some reason.  It just pulls zeros.   Any ideas?

Arsenal

It sounds like you need a master (summary)  detail(individual salesperson) type of report in which you would be creating a master detail link on the salesperson id

Arpitagrawal9

you can use the same query itself create a  data item formula to something like Total(Sales) for month and than in your summary report only drag the salesperson name along with this data item which would giving you monthly aggregated values