Currently I have 2 pivot tables representing the same data in monthly and quarterly view respectively. With this view, the metrics (measures) seems to be repetitive. Is there a solution to have both the monthly and quarterly data in the same pivot table?
Do you want to collate both monthly and Quarterly views into a single view or you are looking for a toggle between monthly and quarterly metrics in a single view?
Not a toggle. I’m looking for a solution where the data can be represented both monthly and quarterly in the same pivot visual.
I can only think of implementing this in the back end, a SQL block for monthly aggregate and another for quarterly aggregate and union them together.