2 Replies Latest reply: Jun 26, 2012 2:41 AM by Robert Zeliznak RSS

    sum for conditional use of formula in graph

      Hi All,


      I would like to sum values calculated by different formulas, which depends on the particular field value, somethink like:


      if (LArt='LDUB15',0,


      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)