Experts, Let me know if you can help me with this scenario. My data is as below ( one ID, Few dimension and Measures)
What I need is as below? When the user selects specific ID and a Dimension combination, what is the best way to dynamically create the "Compare Avg" Value based on the dynamic filter?
Thanks for the help.
Retrieving data ...