[Solved] Display sum() of Pivottable in normal Bar-Graph

[pw]

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

[sir_jeroen]

Could you please post a screen dump and if possible define your problem/wish in terms of the "go sales and retailers" package

[pw]

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?

[sir_jeroen]

Note:
Why in German :S Use the english version :D:D (ok.. i'm from holland ;) )

[pw]

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..... ;)

[sir_jeroen]

Nice... Thanks for sharing the solution...