Display duplicates ( hide column)

[jjustingkm]

I have a table with data like below.

sales I’d Region Supplier

100.          ABC        DD

101.           ABC         DD

I need to hide sales I’d here, without sales I’d , it ends up with only one record since two are duplicates values. Please help

[Quy_Nguyen]

Hi,

Try this expression for Dimension Region:

Dual(Region, SalesID)

[jjustingkm · Accepted solution]

thank you Nguyen