Custom dimension lines in Pivot chart

[pennetzdorfer]

Hey,

after spending some time on "trial & error" I finally managed to build the following pivot chart (the last line "Difference %" caused some headache )

Can anyone tell me, if there is an easier approach than the one I chose... (please have a look at the attached sample qvw).

As I have to extend the chart by adding some more "calculated" lines, the formulas would get rather complex...

Thanks!

Regards, Florian