2 Replies Latest reply: Jul 13, 2014 4:17 AM by Jerry Lau RSS

    counting for historical data using chart

    Jerry Lau

      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!