Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that contains Region, Product and Sales. the sales amount is by product and region. I would like to add a column for regional sales based on the product selected. For example:
Region | Product | Sales | Regional Sales |
---|---|---|---|
North | A | 40 | 100 |
West | B | 50 | 50 |
North | B | 60 | 100 |
I think I can add the new column with a Set Analysis expression. But I can't figure out the Set Analysis. Any ideas? Thanks!
sum (total <Region> Sales)
sum (total <Region> Sales)
Thank you. That was simple and just what I needed!