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:
Gross sales - Discounts - Returns + Taxes: take “Orders / Current total price set“
Duties: “Orders / Current total duties set” table → “presentmentMoneyAmount“ field
Shipping charges: “Orders / Total shipping price set” table → “presentmentMoneyAmount“ field
Fees: “Orders / Total tip received set“ → “presentmentMoneyAmount“ field
Additional fees may vary depending on your store's configuration.