i hv a customer grade change table like this:
customer_id, grade, start_date, end_date, sumcount
1, C, 1/1/2013, 31/12/2013, 1
1, B, 1/1/2014, 31/12/2999, 1
2, B, 1/1/2013, 30/6/2013, 1
2, A, 1/7/2014, 31/12/2999, 1
how can i use a chart (straight/pivot table) to show
dimension: year/month/grade
expression: no of customer (of particular grade) at the period
(p.s. if a customer change more than 1 time in a month, i will consider the grade in his/her last change)
i think this table is not capable of making the chart
so how should i transform it to achieve the goal?
no idea at all, thanks!
