This content has been marked as final. Show 8 replies
I have two tables A and B. A has Customer Group while B has Customer Group Name.
I have customers of A only appear in my pivot table.
Since I need data from B table also but corresponding to only customers of A.
How to match customers of A and B ?
I am using
if ([Customer Group]=CUSTOMER_GROUP_NAME , [Customer Group])
But this gives only customers in Abbreviation like BCGH but not be able to map like 2degrees.