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.

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.