Subtotal Volume based on customer number

[Rollasdoor12]

Hi, I'm trying to write a power pivot measure to calculate the values in the yellow highlighted column, This is effectively a sum of the customer number. I'm sure this is simple but i cant seem to figure it out. The customer number is from a customer table and the product and unit sales are from the Data table (these two table are linked via customer number.

Any help would be great.

 

[severynm]

Welcome!

You shouldnt need to write any measure for this. Assuming you have your relationships between the tables set up correctly, in your pivot table, add the Customer Number as the rows, and Unit Sales as the values. Set the summarization of Unit Sales as "sum" (if it isn't already - I believe that is the default), and Power Pivot does the work for you.