Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've the following data.
Shop | Customer | Total Sales | Total Cost | Total Profit |
---|---|---|---|---|
10 | AAA | 10000 | 5000 | 5000 |
10 | BBB | 60000 | 20000 | 40000 |
10 | CCC | 15000 | 10000 | 5000 |
30 | DDD | 60000 | 40000 | 20000 |
30 | EEE | 800000 | 700000 | 100000 |
40 | FFF | 4500 | 500 | 4000 |
40 | GGG | 1000 | 50 | 950 |
20 | HHH | 3000 | 2500 | 500 |
20 | III | 25000 | 22000 | 3000 |
10 | JJJ | 8500 | 8000 | 500 |
Now i want to group per store total number of customers
Numbers of customers that stands for 90% of the sales per store
Numbers of customers that stands for 80% of the profit per store
Hi,
Please find the attached QVW file.
See attached qvw. If you want to do this with chart expressions only... good luck. I'm not even going to try.