9 Replies Latest reply: Aug 4, 2011 6:43 AM by At titude RSS

    Line chart help!

      Hi All

       

      I have a week as first dimension and product category as second dimension in a line chart. I am using formula "Sum(Sales)". So this line chart gives product category wise week wise. So what I would to do is I would like to show only one line the line chart which gives over all sales of all the product category. I don't want to show seperate line for each product category.

       

      I short what I need is one line which gives consolidated sales of all the product week wise.

       

      Hope my requirement is understandable. If not please let me know.

       

      Regards

       

      Attitude