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

Line chart...each line representing a different year

I am trying to create a line chart of sales by month (x axis) with each year represented by a different line in the chart. Sales Year, Sales Month, and Gross Sales are all separate dimensions in the same table.  The table represent 4 years worth of data.  Not sure how to handle this through Expresssions. 

Any help would be appreciated.

1 Solution

Accepted Solutions
Not applicable
Author

Just add another dimension for the Year,

So your dimensions would be Month, and Year.

Leave the expression as it is.

View solution in original post

4 Replies
Not applicable
Author

Can you post an example on how the data is currently displaying, and how you would like to see it displayed?

Not applicable
Author

I have attached a screen shot showing both the chart and the properties box with the expression.  The chart is showing a line for Gross Written Premium for the sum of 2009, 2010, and 2011.  I need to display each year as a separate line over the months.

Not applicable
Author

Just add another dimension for the Year,

So your dimensions would be Month, and Year.

Leave the expression as it is.

Not applicable
Author

Thanks!  That worked.