5 Replies Latest reply: Jun 7, 2017 9:44 AM by Robin Stoevelaar RSS

    Chart with sales per month per product

    Robin Stoevelaar

      Hi all,

       

      im currently working on analyzing my sales for the past year. Almost everything is done but I miss one graph. I would like to see my sales of the past year per month per productsegment. i want to see the trend, so I tried the Aggr function.

      The syntax I was using was: Aggr(sum(Ordersales),Ordermonth,Productsegment). When I did this, the graph didn't turn up. It says No data to display.

       

      What am I missing here?

       

      thanks in advance!