Totals in crosstab report

[csunitha]

I have 2 crosstab reports, First crosstab total and 2nd crosstab total, needs to be added in 3rd crosstab.

How to add 2 crosstab totals in 3rd cross tab.

[Suraj]

Is it same query or different?
If same just calculate a calculation.

If different, you have to either join or union them to get total.

[csunitha]

They are different Queries.
Cognos is not allowing to Join or Union of queries to get total.......because

Data Item in Query 1

Total(PPG Category) ....In Expression we got " total(currentMeasure within detail [PPG Category])"  This is cognos generated when i add total to that column.

so it is not allowing to me to Join or Union of queries.

[Suraj]

then create your own calculation instead of cognos generated for calculation.

[csunitha]

I created the own calculation instead of cognos generated for calculation then i am getting an error -56

[shahark]

you can delete the total Cognos created and define one of you own.
or
you  can specify "overwrite content" tp yes, unblock the report, add your calcaulation to the total line.
don't forget to add your calculation in the data > properties for the total lavel.

I hope it would help.

Shahar