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?
|1||No Dimension||20||overall Average|
|1||2018||10||Full 2018 Average|
|1||2017||30||Full 2017 Average|
|1||North,2018||10||Full North, 2018 Average|
Thanks for the help.
You can probably do this using LOD expressions, but are you wanting to combine the dimensions to make "North, 2018" ?