How can I plot the Total on Line Chart with two dims

[marcoyukon]

I am attaching an image: Dims are 1) YearMonth and 2) Type (A,B,C,D - identified by each color on the chart.

I can't find on the chart widget a way to plot the sum of each data point on the chart.

Measure: Volume.

I need an additional line that can plot the Total= Sum(volume for A) + Sum(Volume for B), Sum.....C and D for each month.

Regards

[Ivan_Bozov]

Hi! You could use one dimension and several measures, e.g.:

Dimension: YearMonth

Measures:

Sum({<Type={'A'}>}Volume)

Sum({<Type={'B'}>}Volume)

Sum({<Type={'C'}>}Volume)

Sum({<Type={'D'}>}Volume)

Sum(Volume)

If you create them as master items, you will be able to assign default colors as well.

[marcoyukon]

Yes, this solution would work if I pick and choose the dim values, using set analysis. However, this dimension is variable in content, so on the example now I have A...D, but I need ALL the elements selected of the "type" dimension included on the chart. Is there a way I can have the total using all the elements of the selection for the "type" dim ?