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

    Above() function with multiple dimensions

      Hi,

       

      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??

       

       

      BR,

      David