3 Replies Latest reply on Apr 28, 2018 2:17 PM by Okechukwu Ossai

    Number of Times an Attribute occurs.

    David Gabra

      Hello

      I have a vast list of vendor/supplier numbers. Each vendor has many invoices and each invoice is assigned to a 'natural account'

       

      I need to use tableau to (and this is where I need your help) determine the number of different natural accounts assigned to a specific vendor.

       

      Before

       

      Desired Result -  I have tried and in vain, have not been able to add the final column to show the desired result, as shown in the table below.

      The analysis need to be per vendor number - so this should be fixed I assume.

       

       

      Notes, I can't do in excel due to the large number of rows.

       

      Please help. I have attached a sample .twbx file if needed.

       

      Many thanks in advance.

       

      David