Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show only Total for Dimension in line chart

I have a line chart showing year over year growth by month, and I would like for the values on data points to show only the total for prior years or YTD for current year.  I have researched in several other threads that are similar, but don't quite fit my situation so the solutions aren't working for me. 

For the chart below, I want the zeros to disappear, and the numbers on the far right should be the cumulative total for the year.  For the current year, i would like the value to show the current YTD total. 

YOY Line Chart.png

I have attached an example.  Thanks for your help.

1 Solution

Accepted Solutions
sunny_talwar

Or this:

=PolicyMonth = Max(TOTAL <PolicyYear> PolicyMonth)

Capture.PNG

View solution in original post

3 Replies
sunny_talwar

Like this?

Capture.PNG

sunny_talwar

Or this:

=PolicyMonth = Max(TOTAL <PolicyYear> PolicyMonth)

Capture.PNG

Not applicable
Author

That's it!  I forgot about the 'Show Values' option.  Thanks!!