Cumulative Area Chart

[mariamovasheli]

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?  

[JordyWegman]

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).

[Anil_Babu_Samineni]

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)

[sunny_talwar]

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

[mariamovasheli]

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

[sunny_talwar]

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

[mariamovasheli]

Sorry I can't

[sunny_talwar]

Mock up data to test it out?

[mariamovasheli]

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

[sunny_talwar]

Put that in an Excel file and share it here

Uploading a Sample