
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
684 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!
632 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)
655 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!
633 Views
