Line chart 'total line'

[#1]

Hi All,

I have a line chart with sum(Sales) broken down over time (Month) and Category. 

I want to have a total line above the category breakdown so you can easily see the contribution by category to this total as well as being able to actually see the total as an absolute value.  This total line would be over time but not category, so it would change each month along with the category breakdown.

Has anyone managed to do this?

Thanks

GC

[jagan]

Hi,

Can you attach the sample.

Try this expression for Total

=Sum(TOTAL <Period> Sales)

Regards,

Jagan.