Help needed on the dataset - see attached

[Abhishek_8895]

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

 

[p45cal]

See attached

 

[Abhishek_8895]

Hey, thank you so much.
If you can explain how you did will be very helpful for my learning

 

[p45cal]

New measures, eg.:

 

[Abhishek_8895]

New measures, eg.:

View attachment 83899

OK by clicking where exactly?

 

[p45cal]

In the pivot table Fields pane:

 

[Abhishek_8895]

Thank you so much...was missing this one...thanks again