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,
           
      if(LEFT(LArt,4)='LDUB',sum(Price*Volume/1000),
                
      sum(Volume*Price*100)))

       

      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)

      Robert