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?




      Joster Macedo