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?
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.