Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My requirement is to count how many group he changed in last lets say 4 months. Sept being my most recent group. The user want to pivot report comparing last group( also called most recent group )with all previous groups and count him in that group | ||||||||
People ID | MONTH | GRP | ||
1 | jan | A | ||
1 | feb | A | ||
1 | mar | B | ||
1 | apr | B | ||
1 | may | C | ||
1 | jun | D | ||
1 | jul | D | ||
1 | aug | C | ||
1 | sep | A | ||
Most Recent plan GRP | ||||
A | B C D | |||
previous plan group | A | |||
B | 1 | |||
C | 1 | |||
D | 1 |
Please see actual requirement in xls file
Sorry Not able to visualize your final output required!
Can you post a sample table in excel that shows how your final output should be
pls check attached xls document
See attached if it helps