Forum Discussion

Naveenraddi's avatar
Naveenraddi
New Member
3 years ago

Help needed

Hello All

 

I am in need of an urgent assistance on the below 

 

I need to get a distinct value of column B for any 2 unique text value selected through a slicer from column A

 

Slicer -

Product model 

1

2

 

Data table 

Column A ( product model )

1

1

2

2

2

3

3

 

Column B ( Add on product )

Add on product 

A

A

D

C

B

D

 

now , when I select 1 &3 model in slicer I should be able to get the data aa below

 

Matching records 

Product model 

1 - B

3- B

 

Unmatched records 

Product model 

1-A

3-D

 

Please note the data for each product model changes every month that is product model may have some changes with respect to add on product being given as part new additions or removals 

 

The data should change as per my selection in the slicer 

 

Is this possible ? Do I have to create different tables for eavh model ? 

2 Replies