Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Trending Subtotals


Level 2



I have a table that is filtered using advanced filtering to show just what I want. This shows a subtotal in bold with the out of grand total. I want to show a monthly trend for the subtotal but the visualize only allows me to trend the grand total. 

How to I trend the subtotal? I prefer an area chart.


Thank you

2 Replies


Community Advisor

Have you tried creating a segment that takes the place of the filter? Thereby making the grand total the value you are graphing?


Or do you need to see the two separate values?


Level 2

@Jennifer_Dungan Hi Jennifer, 

Yes, I ended up creating a segment. I wanted an easier way for flexibility because my users aren't used to creating & modifying segments. They'll have to modify the segment as things change. I'll have to give them some training. 


Thanks again