Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: pw on 25 Oct 2005 08:40:13 AM

Title: [Solved] Display sum() of Pivottable in normal Bar-Graph
Post by: pw on 25 Oct 2005 08:40:13 AM
Hi folks,

i have a pivot table with about 6 rows and 3 columns. The third on is calculated from the 2 columns before.
In the last row of the pivottable i iadded a SUM-row. Also the 3rd column in the SUM row is calculated correctly.

Is it possible to display the SUM-Row in the normal bar-graph?


Thank you in advance.
pw
Title: Re: Display SUM() of Pivottable in normal Bar-Graph
Post by: sir_jeroen on 25 Oct 2005 10:08:03 AM
Could you please post a screen dump and if possible define your problem/wish in terms of the "go sales and retailers" package
Title: Re: Display SUM() of Pivottable in normal Bar-Graph
Post by: pw on 25 Oct 2005 10:18:41 AM
In the Screenshot, the pivottable has a SUM row (last row). I want to display the third column named "Deckungsbeitragsquote" within the second bar graph.

I think i need a union join for this to get this value into the dimension?
Title: Re: Display SUM() of Pivottable in normal Bar-Graph
Post by: sir_jeroen on 25 Oct 2005 10:19:55 AM
Note:
Why in German :S Use the english version :D:D (ok.. i'm from holland ;) )
Title: Re: Display SUM() of Pivottable in normal Bar-Graph
Post by: pw on 25 Oct 2005 11:31:29 AM
I solved it myself :-)

Here is how i did it:

UNION Select of
- all sums of each entry of dimension
- complete sum of all dimenions

This brings up a new row with the sum i need for the bar graph.
The red bar in the screenshot is the TOTAL of the other 4 bars..... ;)
Title: Re: Display SUM() of Pivottable in normal Bar-Graph
Post by: sir_jeroen on 25 Oct 2005 11:38:36 AM
Nice... Thanks for sharing the solution...
Text only | Text with Images