how to calculate...

[#1]

Hello,

       Everyone, I have a problem about making a chart to calculate ...

       Please see the attchment for sample,  and I need to make a chart like this :

     

   How to?

[sunny_talwar · Accepted solution]

May be like this

t:

LOAD * INLINE [

    ID, Year, Level

    ID001, 2014, A

    ID002, 2014, B

    ID003, 2014, C

    ID001, 2015, B

    ID002, 2015, C

    ID003, 2015, A

];

QUALIFY *;

UNQUALIFY ID;

t1:

LOAD *

Resident t;

Pivot Table

Dimensions:

t1.Year

t1.Level

Year

Level

Expression:

=Count(If(Year > t1.Year, ID))

[#3]

thanks a lot.  That's what I'm looking for.