Hi,
I'm trying to a create a chart that will show the number of customers by the volume over Quarters...I've tried using the fractile function and can't get it to work...
Data Looks like this...
I want to see the number of customers that make up the 25%,50%, and 75% fractiles...
ShipDate.Year - Quarter | Customer Count | # of Orders |
2009-Q4 | 685 | 35087 |
2009-Q2 | 659 | 35252 |
2009-Q3 | 657 | 33169 |
2009-Q1 | 576 | 29379 |
Thanks for looking and any help would be greatly appreciated.