Pivot on 2 YearMonth, compare in field

[#1]

Hello,

I'm having 2 data tables, Expired Vouchers & Voucher Sales.

Sales Vouchers had field Sales_YMonth, Sales_Qty

Expired Vouchers has Expiry_YMonth, Sales_YMonth, Expiry_Qty

In my Pivot i'm having for Each Expiry Month, the Sales_Ymonth en the Expiry Qty., Expiry_YMonth is the Row, Sales_YMonth is the Column, expiryQty is the value.

Nouw i would like to have a field next to it that show for the Sales_YMonth the Complete Sales on that Sales_YMonth, (In order to calculate the percentage of the expiry qty).

As Selection is on Expiry_Yonth i still can 'see' the complete Sales_Vouchers table, but how do i code the if, or the set that would read in pseudocode ..

SUM( All the Sales_Qty for this Sales_YMonth Column) ...

[#2 · Accepted solution]

Silly me, <TOTAL> just did the job, was again looking far to far in the set analysis.