Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
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))
thanks a lot. That's what I'm looking for.