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.
