Expand my Community achievements bar.

SOLVED

Trending Subtotals

Avatar

Level 2

Hello,

 

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

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?

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor and Adobe Champion

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?

Avatar

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

Rhonda