7 Replies Latest reply on Jun 6, 2018 8:37 AM by TarunDeep Chhabra

    Subtraction between domains of a dimension

      Each row in my Excel file represents the document for a single transaction. The columns contain info such as Type (i.e. Invoice, Returns, etc), Doc Amount, currency ID, exchange rate, customer name, etc..

       

      My current visualization only shows the total IN (invoice) and RT(return) amounts per customer. I'd like for it to show IN less RT, in order to see overall sales per customer. Also, I'd like for exchange rate to be taken into account. How do I do these?

       

      (Type is a dimension and Doc Amount is a measure. When trying to create a calculated field, IN and RT are not displayed under 'Fields', hence I'm not sure how to insert them into the formula. I'm not familiar with formulas either.)

       

      Thank you.