Its easy to create the trend chart using pivot tables if I have Monthly data
for example YEAR, MONTH, ORDER_COUNT
But I've an excel where I have
CUSTOMER_NAME, YEAR, MONTH ,ORDER_COUNT
In my final output graph I do not want to show CUSTOMER_NAME , I want to create a MONTHLY ORDER_COUNT line-graph showing comparison for 25 percentile and 75 percentile 90 percentile of CUSTOMER.