11 Replies Latest reply: May 24, 2018 3:49 AM by Jordy Wegman

# Cumulative Area Chart

HI,

I need to make cumulative area chart. on Y axis to have cumulative percentage of sales. and also sort by companies sales Descending.

Can You Please Tell me how Can I achieve this?

• ###### Re: Cumulative Area Chart

Do you need the time as dimension on the x-axis?

Dimension 1:Put the time as a dimension

Dimension 2: Put the companies as a dimension

Measure 1: For the % on the Y axis: Sum(Volume) / Sum(TOTAL Volume).

• ###### Re: Cumulative Area Chart

This is really tough to explain, Better if you can make sample QVF file?

Num(Rangesum(Above(Sum(SALES),0,rowno(TOTAL))),'#,##0%')

Or

Rangesum(Above(Sum(SALES),0,rowno(TOTAL)))/Count(FieldName)

• ###### Re: Cumulative Area Chart

sales in descending order? But you have the x-axis to be Month... you want to reorder month to be based on sales?

• ###### Re: Cumulative Area Chart

no I want descending on Y axis where I have sales. to start With the company witch has Highest Volume of sales and then who have less.this Cumulative Area To be sorted

• ###### Re: Cumulative Area Chart

Oh okay... I got you... would you be able to share a sample qvf to test this out?

• ###### Re: Cumulative Area Chart

Sorry I can't

• ###### Re: Cumulative Area Chart

Mock up data to test it out?

• ###### Re: Cumulative Area Chart

Yes but  I don't know how To share mock Up data

• ###### Re: Cumulative Area Chart

Is it okey?

• ###### Re: Cumulative Area Chart

Checking