Print Page - Adding a row that calculates the difference between two totals in a crosstab

Title: Adding a row that calculates the difference between two totals in a crosstab
Post by: Roberto on 07 Oct 2024 09:45:45 AM

So I have a crosstab with information on the following format

My crosstab looks like this

How do I add a column that subtracts the sum of all the title amts in group A minus the sum of all the title amts in group b?

Here is an example in excel:
(https://imgur.com/a/hL6N6u8)
https://imgur.com/a/hL6N6u8

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Roberto on 07 Oct 2024 09:45:45 AM