Thomas Kuriakose
Active Member
Respected Sirs,
I am struggling to get a display of batch numbers which have moved from Change Type 1 (PP) to change type (A1,A2,A3) as well as change type 2 in the attached file.
I tried to prepare a pivot table, but the value fields does not have text to summarize.
Kindly guide on how to get the result as detailed in the required result tab. The example listed is for PP to A1 and Change type D.
Thank you very much for your support always.
with regards,
thomas
I am struggling to get a display of batch numbers which have moved from Change Type 1 (PP) to change type (A1,A2,A3) as well as change type 2 in the attached file.
I tried to prepare a pivot table, but the value fields does not have text to summarize.
Kindly guide on how to get the result as detailed in the required result tab. The example listed is for PP to A1 and Change type D.
Thank you very much for your support always.
with regards,
thomas