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?
sales in descending order? But you have the x-axis to be Month... you want to reorder month to be based on sales?
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
Oh okay... I got you... would you be able to share a sample qvf to test this out?
Sorry I can't
Mock up data to test it out?
Yes but I don't know how To share mock Up data
Put that in an Excel file and share it here
Uploading a Sample
Is it okey?
Retrieving data ...