Pivot table - Sum by customer

[qlikviewaf]

Hi,

i have a pivot table where i have several rows for a customer like

Customer  ,  Line , Sales

A,1, 100

A,2,400

A,3,500

B,4,100

B,5,100

How can i calculate total by customer on the pivot that is repeated for each row ? like follow

Customer  ,  Line , Sales, total

A,1, 100, 1000

A,2,400, 1000

A,3,500, 1000

B,4,100, 200

B,5,100, 200

Thank you

[melghandour89]

try to create a measure for total as :Sum(Sales)  and dimension for customer