Multiple tax ID for same vendor

[Anonymous]

Hi,

I want to show multiple/different vendors who have the same TAX ID.

E.g.

VendorNum    Tax ID

Vendor1          1234

Vendor2          1234

Possible to show that in a straight table?

Thanks,

Sunny

[Anil_Babu_Samineni]

May be use table Box? Unless why forcing to achieve this in straight table.

[Anonymous]

Yes, you can show the values.

[tomasz_tru]

Use measure: Concat(Distinct VendorNum, ',') and Tax ID as Dimension

Tomasz

[sunny_talwar]

May be like this

Dimension

VendorNum

Tax ID

Expression

If(Count(DISTINCT TOTAL <[Tax ID]> VendorNum) > 1, 1, 0)

And then you can hide the expression from the presentation tab, if you only wish to see the two fields in your straight table chart

[Anonymous]

Thanks, this seems to work fine, just 1 more thing, I have a lot TAX IDs values "No Tax ID" and that's appearing too. How do I remove that from the output?

[sunny_talwar · Accepted solution]

May be this

If(Count(DISTINCT {<[Tax ID] -= {'No Tax ID'}>} TOTAL <[Tax ID]> VendorNum) > 1, 1, 0)

or

If(Count(DISTINCT TOTAL <[Tax ID]> VendorNum) > 1 and [Tax ID] <> 'No Tax ID', 1, 0)

[Anonymous]

Thanks a lot, it works