How to replicate Sales Report from Shopify Analitics with the exported raw data?

📘 According to Shopify Analytics → Sales report definitions page, the total sales formula is as follows:

Gross sales - Discounts - Returns + Taxes + Duties + Shipping charges + Fees:

1. Gross sales - Discounts - Returns + Taxes: take “Orders / Current total price set“

2. Duties: “Orders / Current total duties set” table → “presentmentMoneyAmount“ field

3. Shipping charges: “Orders / Total shipping price set” table → “presentmentMoneyAmount“ field

4. Fees: “Orders / Total tip received set“ → “presentmentMoneyAmount“ field

📘 Additional fees may vary depending on your store's configuration.