Skip to main content
Level 2
November 28, 2022
Solved

Trending Subtotals

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jennifer_Dungan
Jennifer_DunganAccepted solution
Adobe Champion and Community Advisor
November 29, 2022

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?

2 replies

Jennifer_Dungan
Adobe Champion and Community Advisor
Jennifer_DunganAdobe Champion and Community AdvisorAccepted solution
Adobe Champion and Community Advisor
November 29, 2022

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?

Translate
RYJonesAuthor
Level 2
November 29, 2022

@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

Translate