Notifications
Clear all
Power Pivot
3
Posts
2
Users
0
Reactions
88
Views
Topic starter
I have a pivot table report with a calculated field using multiplication.
The total is not calculated correctly.
Posted : 16/02/2022 9:06 pm
Hi Johnson,
Welcome to our forum. The total is taking the sum of the daily rate x the sum of the working days, rather than the sum of the normal rate. This is by design. If you want it to sum the normal rate then you can either add the 'normal rate' field to your source data rather than as a calculated column, or you can use Power Pivot and a DAX measure.
Mynda
Posted : 17/02/2022 6:56 am
Topic starter
Hi Mynda,
Thanks for your response.
Will take your suggestion and see how it work out.
Regards,
Johnson
Posted : 17/02/2022 7:20 am
