Abhishek_8895
New Member
Experts,
I have done almost everything like the data model etc and have the expected result in the Language Wise summary Sheet and Summary sheet
All I need help is that from column I,J,K which I have calculated seperately, is there a way I can do it in the pivot itself thorugh the Pivot Analyse tab or something or any other way you can recommend to achieve the required expectation in a more easire way.
Attaching my sheet where you could see all I have done - Expectation is what you see in Language wise summary sheet and the Summary sheet.
Please let me know for any questions
I have done almost everything like the data model etc and have the expected result in the Language Wise summary Sheet and Summary sheet
All I need help is that from column I,J,K which I have calculated seperately, is there a way I can do it in the pivot itself thorugh the Pivot Analyse tab or something or any other way you can recommend to achieve the required expectation in a more easire way.
Attaching my sheet where you could see all I have done - Expectation is what you see in Language wise summary sheet and the Summary sheet.
Please let me know for any questions