Skip to Content
0
Jan 23, 2023 at 08:33 AM

DWC and SAC Aggregation on constant dimensions in calculation measure

307 Views Last edit Jan 23, 2023 at 11:48 AM 2 rev

Hi all

I am using DWC to consume the data and building reports in SAC. I really need expertise help to let me know, about one of the calculations that I am trying to get.

I have lets say, Average market based on Weightage and reviews in the report.

When I add, more dimensions to the report layout - accordingly the data gets to the granular level and the calculations are based on the new dimensions. However, I need the calculation to be performed on the constant dimensions which I want and the Average market should not change even after adding new dimensions to my layout.

Demonstrated with below example data.

average-market-calculation.png

Please let me know, how this can be calculated.

Note: Please note that, I have many markets / dates / products on which this calculation needs to be applicable. The above is only a sample data.

Attachments