I wanted to compare the sales of customer by using property control etc

[Manjunath Jannu]

Hi Spotfire team #Dr spotfire

I have requirement

Ihave two groupGroup A and Group B in each group i have 10 same dealers

if i select dealers in text areafrom Group A ,the same dealers should not reflect in group B so i wanted to compare there sales

any help how can do this in spotfire

[Khushboo Rabadia]

Can you provide the sample dataset and expected output

[Manjunath Jannu]

HI khushboo R

Please find the attached file .

if i select Dealer 1 in primary same dealer should not reflect in comparison group so then i can make a caparison of Deal 1 and Deal 10

[Khushboo Rabadia]

You can create a calculated column for comparison groupBlike:

case when [GroupA]!= "${GroupA}" then [GroupA] end

Have the unique values of GroupB column in comparison group property control.

So whenever you select "Dealer1" in GroupA prpoerty control, GroupB column will have all values other than dealer 1 and the same will be shown in property control

[Manjunath Jannu]

Thank you kushaboo One more query how to create Drop Down List with Multiple Select in spitfire i need it in drop down only not other like check box etc Thank you in advance