Hi,
How are you all.
I want to create a calculated field which will do a sumproduct of all activity fields with the AHTs and result to be shown in pivot with the name production hrs.
Tried doing it but could not ....Need expert help with this. Would be grateful if this can be done. I have attached the file with query, AHT and required data.
Query
: Want Production Hrs calculation to be done using calculated field in the below mentioned pivot. Formula for production hrs calculation should give result as sumproduct of all activities (highlighted in yellow) with the AHT (highlighted in red).
regards,
Aria
How are you all.
I want to create a calculated field which will do a sumproduct of all activity fields with the AHTs and result to be shown in pivot with the name production hrs.
Tried doing it but could not ....Need expert help with this. Would be grateful if this can be done. I have attached the file with query, AHT and required data.
Query
: Want Production Hrs calculation to be done using calculated field in the below mentioned pivot. Formula for production hrs calculation should give result as sumproduct of all activities (highlighted in yellow) with the AHT (highlighted in red).
regards,
Aria