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?
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).
This is really tough to explain, Better if you can make sample QVF file?
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