The Aggregation Scope-How do we define when there are 2 dimensions?

[newbie_sm]

Following on Henric Cronstrom's Post on "The Aggregation Scope", can you provide guidance on how to define aggregation when there are 2 dimensions. E.g.

In this table, I have 2 dimensions = Product (Rows) and Year (Columns).  What should the aggregate function to use in order to arrive at the last set of numbers highlighted in 'RED'? i.e. share for Products to be 100% for every year.

thanks

[hic]

Sum(Sales)/Sum(total <Year> Sales)

[newbie_sm · Accepted solution]

THANKS - the formula worked!