Forum Discussion

asad98's avatar
asad98
Regular Visitor
5 years ago
Solved

slicer filtering based on 2 columns

Hi guys any help will be very appreciated, the case is as follows : - I have 2 tables - Competitor A & Competitor B. Each of them has a column called - "Product Condition" and have a many-to-many re...
  • amitchandak's avatar
    amitchandak
    5 years ago

    asad98 , Create a common dimension product and product conditions or both in one. Join that with both tables and analyze them together

     

    Refer how to create common/bridge table

asad98's avatar
asad98
Regular Visitor
5 years ago

Hi guys, really appreciate your replies. I am attaching some sample data: -

Competitor A : -

Ref number | Condition

1 New

2 Pre-owned

1 Unworn

3 Pre-owned

Competitor B : -

Ref number | Condition

1 New

2 Pre-owned

3 Unworn

4 Pre-owned

Competitor A and B have a many-many relationship with ref number as the key field.

I want to add one slicer which can slice both the tables having values - New, Used, Unworn, also the reference numbers have to be the same in the output. The desired output would be:-

If new was selected :-

Ref number | Condition

1 New ------ (From Competitor A)

1 New ------ (From Competitor B)

If Pre-owned was selected :-

Ref number | Condition

2 Pre-owned ------ (From Competitor A)

2 Pre-owned ------ (From Competitor B)

My use case is to compare prices from 2 competitor websites taking into account the variables that affect the price like the condition would affect the price of any product and then take an average price for that product and compare the pricing of two competitors selling the same product