1 Reply Latest reply on Oct 13, 2012 7:59 AM by Alex Kerin

    Count of Products in total and in a selection

    Tony Course

      I want to count how many products I have, and also how many I have selected.


      I have say 700 products in my extract.


      I select say 3 departments with 200 products.


      On the same vis I want to show 200 products and 700 products


      To do this I have created a duplicate of the same extract.


      I use the count distinct against product name (and it calculates - the amount selected) ie 200


      However I can't get Tableau to look at the copy of the extract and calculate the total. ie 700

      (although I have successfully done this with other calculations eg Sales for selection and in total)


      I attach a sample worksheet with some sample data.




      Message was edited by: Tony Course  I have now added packaged workbook. sorry for the mistake.