3 Replies Latest reply on Jan 19, 2012 3:04 PM by Dimitri.B

    Filter and Calculation

    Joster Macedo

      Hello Everybody,

       

      I'm a new Tableau user and I encountered a issue with my table that I believe someone here will be able to help me.

       

      I have a table with all the invoices generated in the company. This table includes dates, category, products, quantities and amounts invoiced. The issue I have is that under category the invoices are categorized as sales, returns etc. So if I create a filter selecting only sales, these are not the actual sales since I have to subtract the numbers that show up when I filter using only the returns category.

       

      I know I can create two worksheets, one showing only sales and the other showing returns and then do this subtraction in Excel, but is there a way of doing this automatically in Tableau?

       

      Thanks,

       

      Joster Macedo