Add a Pivot Summary into a Email & changing values into Euro

Hi Community,

I have to send out a email to a Dist List, I gotten this to work, now i need to make changes.

I need to add a Add a Pivot Summary view into the Email and show the Sales Order Values & Shipped Lines values in Euro (2 Decimal places) in both the excel attachment, and the Summary in the email.

Can anyone please help here

Attaching "copies" of the Raw Data files, the WF, and the email I get.

I'd like to add the below into the email along with the current text I have.

Order Wave	Sum of Sales Order Lines Shipped	Sum of Total Sales Order Lines	Sum of Ext Shipment Value	Sum of Ext Order Value
W1	200	299	€ 5,712,225	€ 15,417,501
W2	15	180	€ 43,215	€ 1,549,096
W3	0	219	€ -	€ 25,427,873
Grand Total	215	698	€ 5,755,440	€ 42,394,471