
Contributor III
2022-04-28
09:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The Aggregation Scope-How do we define when there are 2 dimensions?
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
669 Views
1 Solution
Accepted Solutions

Contributor III
2022-05-04
03:04 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
THANKS - the formula worked!
617 Views
2 Replies

.png)
Former Employee
2022-04-29
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum(Sales)/Sum(total <Year> Sales)
640 Views

Contributor III
2022-05-04
03:04 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
THANKS - the formula worked!
618 Views
