Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
In a table, I want to show the same result for each line.
Example :
Category | Product | Sales | Total Sales by category
Category A - Product Z - 10 - 30
Category A - Product X - 10 - 30
Category A - Product Y - 10 - 30
Catergory B - etc.
I tried : aggr(sum(sales), category) but it doesn't work..
Thank you
Hi! Try
Sum(Total <Category > Sales)
Regards,
Jaime.