My Requirement is to Generate a Pivot report in the Below mentioned output in excel doc . This report is usually generatedMonthly. So when report is generated he is counted in previous grp as well as new grp.For example in monthof JAN person 11111 was in plan A . He was in same plan in month Feb . but in feb he moved from Plan A to plan C . so in above mentioned report he will be counted in plan A as well as plan C.PFA my test qv. to help me fixexpression !!