Nesting rows in merged query visuals

I am currently using merged queries to calculate % change of media spend between two time periods. I use 2 dimensions, channel and platform, to see spend at a more granular level. The primary merged query shows data from the past 7 days, while the comparison period shows data from the last 14 days. Using this information I made % change calculated fields for spend. I want the spend and other metrics to be able to roll up into channel and platform like normal visuals do when the sub-totals option is checked. With my current merged query, the sub-totals option is no longer available. Is there a way to nest the rows based on the different dimensions for merged queries?

0 0 250
0 REPLIES 0
Top Labels in this Space
Top Solution Authors