Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
Num(Rangesum(Above(Sum(SALES),0,rowno(TOTAL))),'#,##0%')
Or
Rangesum(Above(Sum(SALES),0,rowno(TOTAL)))/Count(FieldName)
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