Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
67
Views
Topic starter
Hello Friend;
Good morning
In workbook attached , there is column for Buchanan Total and Davolio Total. I am having difficulty calculating commission percentage (i.e. 35%) for January 2017 - December 2017 & January 2018 - March 2018. I am positive that we need to calculate using calculated item.
Will greatly appreciate your help.
Thank you.
Have a great day.
Posted : 18/04/2018 8:07 am
Hi Mitul,
You need a calculated field. See file attached and tutorial below:
https://www.myonlinetraininghub.com/excel-pivottable-calculated-fields
And for your understanding, here is a tutorial on Calculated Items:
https://www.myonlinetraininghub.com/excel-pivottable-calculated-items
Mynda
Posted : 20/04/2018 7:31 pm
