This content has been marked as final. Show 2 replies
I would like to sum values calculated by different formulas, which depends on the particular field value, somethink like:
See attached example QVW
if I use it in pivot table with more dimensions, it works fine BUT if I Use it in Graph with one Dimenson (Group), it uses only the last formula (sum(Volume*Price*100) ) for every row and kumulate it. I cant use additional dimension.
The right sum Value for dimension Group in Graph is 11 200,070 (NOT 18 200)
Does somebody has an idea how to sole it.
thanks a lot for your Idea(s)