Forum Discussion

TamlerloversKant's avatar
TamlerloversKant
Copper Contributor
May 18, 2022

PowerPivot Table - Total Column as a Multiplication of Values

Good afternoon,

I am trying to create an additional total column in power Pivot Table as per the yellow highlighted column in my Snip Below:

The Total Rate is the "Rate" column, multipled by the "Total Hrs";

The Data for Rate for certain Roles is coming from a Lookup table which is linked to a data table containing all of the relevant hours worked by specific roles on specific Dates.

 

any assistance would be greatly appreciated, thankyou.

 

Resources