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!

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

Cognos Report Studio 8.4 - data from multiple periods in columns

Status
Not open for further replies.

CrystalLion

Programmer
Jan 3, 2007
113
US
Ideally I would like to have one report with data from two reporting periods, which would be user prompted.

Something like:

Product | Curr Mo Bal | Prior Mo Bal | Change
Pernsup | 300 | 500 | 200
Widget | 100 | 200 | -100

All data is coming from one view: HISTORY_VW

Any help is appreciated.
L [sunshine]
 
If Curr Mo Bal & Prior Mo Bal refer to the same view column you can define 2 queries and join over Product within the report. this nets a 3rd query which allows the calculation for the change column.

Ties Blom

 
Thanks. I am giving it a try now. I'd like to add another data item to the crosstab. I'd like to see Value and Count. However, the count is not based on the Product level, it's based on the individual Accounts that belong to the Product.

something like:

Product | Curr Mo Bal | Curr Count | Prior Mo Bal | Change
Pernsup | 300 | 10 | 500 | 200
Widget | 100 | 20 | 200 | -100

 
If the resultsets are small, then it will probably work to use the 3rd result query as input for a join with a 4th that performs the count resulting in final query 5 to build the crosstab!!

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top