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.