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

TOTALS for each column in crossTab ?

Started by sanchoniathon, 02 Jun 2009 12:57:00 PM

Previous topic - Next topic

sanchoniathon

Hello,
1- I have this crossTab with lines and columns and 1 implicit measure on the corner of the crossTab.
2- I need to have TOTALS of all the columns of my crossTab
3- I tried by adding a crossTab space on the last line of my crossTab and it kind of works but not completely. Only the columns associated with
the implicit measure (the measure on the corner of my crossTab) seems to have a TOTAL.
4- But i need TOTAL for all other columns (some of them are also different measures)
anyone has any suggestions ?
Thanks !

Kleber

Quote from: sanchoniathon on 02 Jun 2009 12:57:00 PM
Hello,
1- I have this crossTab with lines and columns and 1 implicit measure on the corner of the crossTab.
2- I need to have TOTALS of all the columns of my crossTab
3- I tried by adding a crossTab space on the last line of my crossTab and it kind of works but not completely. Only the columns associated with
the implicit measure (the measure on the corner of my crossTab) seems to have a TOTAL.
4- But i need TOTAL for all other columns (some of them are also different measures)
anyone has any suggestions ?
Thanks !

Add a calculated field of the form "[measure] for [A,B,C]" (in Oracle this is called the analytical funtions, sum(x) over (partition by a,b,c) )  where A,B,C are the columns in your left side of the crosstab, then place this calculated field right next to ABC, I don't think you can put the row total on the right side as one would like to. so your rows woud look like: A,B,C, Subtotal, measure, measure, etc.

Hope this helps.
Kleber.