I have started using Tableau recently. I performed join operation between orders and returns of global superstore data set.
I need help to calculate refund to get list of orders returned by the customers . It will help me to proceed further if I know refund. How to calculate refund?
I would join both sheets on ORDER id column - then filter it on Returned = 'Yes'. Then take the sum of sales.
Let me know if you need more details.