5 Replies Latest reply: Jul 26, 2016 5:14 PM by Azmina Virani RSS

    Above() function with multiple dimensions



      Please find the attached QV with my problem.


      Here is a description:


      I use the above function to calculate projected stock values. Now I want to display the projected stock values on date and product group (two dimensions). So I introduced TOTAL in the expression to take care of the "multiple dimensions with above function"-problem, so far so good. The pivot returns the correct, wanted figures, however when I try to convert it to a line chart (with the various product group dsiplayed as seperate lines) I do not get it to work.


      Note that flipping the line chart to a pivot chart returns the correct figures in the pivot. Also, chosing one 'Product Group' works fine and returns the correct results for both line chart and pivot.



      How do I get my line chart to work??