My Requirement is to Generate a Pivot report in the Below mentioned output in excel doc . This report is usually generated Monthly. So when report is generated he is counted in previous grp as well as new grp. For example in month of 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 fix expression !! |