This content has been marked as final. Show 3 replies
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.
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.