Skip to main content
Solved

Annual values do not display when collapsing year dimension

  • February 27, 2025
  • 5 replies
  • 86 views

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?

Best answer by Min Li

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

 

This post may help.
 

 

5 replies

Min Li
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • March 3, 2025

@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.


  • New Here
  • March 4, 2025

I have the same issue


Min Li
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • Answer
  • March 5, 2025

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

 

This post may help.
 

 


  • Author
  • Apprentice Author
  • March 5, 2025

Moving scenario to the top of columns worked, thanks!


  • Author
  • Apprentice Author
  • March 7, 2025

@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