Currently in the assignment which i am working , the report has
1.Around 7 business critical metric involved. These metrics needs to be represented in a format which includes less number of pages and all comparisons should be included.
2. So this old report has lots of bookmarks and combination of dynamic measures Example ,on a single page, bookmarks to move between these 7 metrics and then within that switch between Previous month and STLY comparison for Tabular views and also an ability to move across graphical view and tabular view.
So to handle all this I am planning to use the approach of Dynamic measure creation using switch statement which would automatically reduce the book marks in the report( the same thing what I have done in the sample report attached - exact use case), further using a combination of page navigation to move between tabular or graphical view on respective pages. And not to forget inclusion of a menu page in the beginning where in user would select the metric which would get sync across different page and do the necessary analysis.
So if you see considering 7 measures and each measure having PM, MOM , MOM var, MOM Var % , STLY, STLY var and STLY var %, CM measures which totals upto 8 for each metric and considering 7 metrics in total. The total number of metrics just increases wherein i am doing the same calculation.
So considering above points I wanted to explore the use of Calculation groups as part of solution for this assignment wherein along with reducing the number of bookmarks, number of measures can also be reduced and same functionality can be retained.
It would be great if you can provide your expertise here on calculation group to help resolve this use case.