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

Total() position ran rigth on crosstab!

Started by DALSOM, 10 Apr 2012 10:54:20 AM

Previous topic - Next topic

DALSOM

 :o

Hi,
I have a crosstab in what i use a total(currentMeasure within detail [myDim]) for show the rows subtotal and rows total.
Rows total is same function and is already working. But the subtotal ones, not. This are showing total on the crosstab of the next column, and on the first column show the total of the last column.

Then, I tried changing solve order, and same happened. How I can work around this issue?
I am using Report Studio 8.4.

Will show like this :


----------------------------------------------------------------------------
ColTitle1  **  ColTitle2 ---  RowTitle1  -  RowTitle2    --   Total
----------------------------------------------------------------------------
*             **   ColDes1 ---       5          -       10          --    15
*  DesC1 **   ColDes2 ---       3          -       20          --    23
************************************************
*              **  SubTotal --        38        -        8           --     30
************************************************
*  DesC2  **   ColDes1--        2           -        1          --      3
*               **   ColDes2--        5          -        7          --      12
*************************************************
*               **  SubTotal--      15           -        7         --      7
*************************************************
*  Summary  **                     15            -       38        --     53
**************************************************


Watch Subtotals rows, resultset is ran one position to the right!
Please help!