Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
THANKS - the formula worked!
Sum(Sales)/Sum(total <Year> Sales)
THANKS - the formula worked!