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

Difference between 2 lines of 2 differents cross table

Started by GuiCoRe, 28 Aug 2014 04:15:17 AM

Previous topic - Next topic

GuiCoRe

Dear All,
First i'm using Cognos BI 10.1 report studio & SQL Server.

I have 2 cross table (see in attachement), which contains a line call "total" which is the total of all dynamic lines (Elements of line are prompted).
Both cross table are using the same table (but differents requests) to display datas, only the line are dynamics (choose by the users).
So, 2 requests on the same table with different filter.

I'm trying to have another cross table with the difference of the lines total ( in the printscreen, it should be total1-total2) with the same columns.
Can you help me about this ?

I precise that I use relationnal datas.

Thank you for your help,
GuiCoRe