Skip to main content

I have a table with data displayed quarterly across the columns. The data in the metric I am using is dimensioned by month, and I am using Month > Quarter as my primary time dimension in the table. I also have a Month > Year dimension stacked on top of the quarter. I use the Sum aggregator on the quarter to display annual totals. When I collapse the year, the totals go away and the entire column is blank. How can I display annual totals when collapsing the year?

I have other tables with the same time dimensions/aggregators, and the annual totals display correctly when collapsing the year so this seems like it might be a bug?

​@aaronsolomon It should work unless the metric is not a numerical type that support sum aggregator .
It would be helpful to understand your problem if you can attach a screenshot here.

I have the same issue

​@aaronsolomon Please make sure that the Scenario is put on top of the columns .

 

This post may help.
 

 

Moving scenario to the top of columns worked, thanks!

​@DerekKramer in case you missed the response above - if you move Scenarios to the top of the column dimensions, the output should work as expected

Reply


Ask your question here!

Terms & ConditionsCookie settings