Set Analysis Expression for Regional Sales

[Anonymous]

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!

[maxgro · Accepted solution]

sum (total <Region> Sales)

[Anonymous]

Thank you. That was simple and just what I needed!