Hi Shivang-

I created two calcs to do this.  You can filter on this calc, I just left it in there for you to see how it worked.

Beverage Isolation

IF [Category] = "Beverages" THEN 1 ELSE 2 END

Order Contain Beverages?

IF {fixed [Sales Order] : MIN([Beverage Isolation])} = 1 THEN "Yes" ELSE "No" END

9.3 attached.

Hi shivang desai,

which version of tableau desktop you are using. The second calculation was done by using LOD expressions which will be supported by the (>x versions. Please make sure that you are using the 9.0 or higher versions.

Hi Shivang desai,

You are using lower version than 9.0 . So, LODs are not supported in that 8.2 version. if you want to use LOD then you need to upgrade your TD to 9.0 or higher version or else you need to write the calculations manually by breaking down them it into several parts.

Hi Shivang

I tried to calculate the things the way you have want but I am stuck at an issue, which is my calculations are giving the proper order ID which contains the beverages. When I use them it only considers the Beverage and ignores the second item from the order. I think it need to be achieved using some restructuring of data.

Guys Please take it forward from here if possible.

Attaching the 9.2 (Tried achieving without LOD)

Truly need some expert advice/guidance. Mahfooj, can this be achieved without using the LOD?

Thanks and Regards,

Ashish Chaudhari

We have to biuld "BRIDGE TABLE" at DB level to implement the N: N Relationship. (Namy to Many Relationship between 2 Tables).

Hi Adam,

is there any workaround for this in tableau 8.2 version?

I am sure this can be possible without using LOD functions. (tableau must have considered this scenarios before releasing 8.2 version)

Thanks and Regards,

Ashish Chaudhari

Hi Kumar,

I think your suggestion is right. Can you try to demonstrate it? Even I had a say that there is some data restructuring or something at the data level needs to implement which will consider multiple items for one order.

Thanks and Regards,

Ashish Chaudhari

Books_Table

Book     Author

B1          A1

B1          A2

B1          A3

B2          A1

B3          A2

B4          A3

Sales_Table

T_ID     Book     Sales

T1     B1          100

T2     B2          100

T3     B3          100

T4     B4          100

As per the SalesTable, Total Sales Volume is 400.

But when we connect these two Tables using Books_Table.Book= Sales_Table.Book

Author     Sales

A1          200

A2          200

A3          200

Here we get the Total Sales as 600, but as we known there is Total Sales AMT is 400.

Here 1 Book (B1)  is authored by 3 Authors, so B1 sales AMT is reflecting to 3 Authors.

We can say 1 Book can be written by multiple Authors and 1 Author can write multiple Books. (Many to Many).

Here we have to create a NEW BRIDGE TABLE @ DB Level.

A bridge table
sits between a fact table and a dimension table and is used to resolve
many-to-many relationships between a fact and a dimension. Bridge
table will contain only two dimension column ,key columns in both dimension
.

Suppose there are two dimensions Customer
and Region,

create table
Customer(Customer_id
int, Name varchar(110));

create table
Region(Country_id
int, Desc varchar(50));

Bridge
table is created by joining the two tables Customer and Region using dimension
keys

Best Regards

Kumar

Trying this out.

Thanks Kumar.

Hi Shivang,

compute the table calculation in filter at cell level.