Skip to main content
Solved

Annual values do not display when collapsing year dimension

  • Feb 27, 2025 11:02 PM UTC
  • 5 replies
  • 397 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.
 

 

View original

5 replies

Min Li
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • Mar 3, 2025 7:20 PM UTC

​@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
  • Mar 4, 2025 12:31 AM UTC

I have the same issue


Min Li
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • Answer
  • Mar 5, 2025 6:11 PM UTC

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

 

This post may help.
 

 


  • Author
  • Wallflower
  • Mar 5, 2025 6:22 PM UTC

Moving scenario to the top of columns worked, thanks!


  • Author
  • Wallflower
  • Mar 7, 2025 6:42 PM UTC

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