Trellis chart of multiple charts per dimension

[L_VN]

Hello. I am looking to create a trellis chart consisting of tables of order details per organisation (where Flag = 1), but I am struggling to limit each table to only consist of order for that organisation.

My script looks like this:

F:
[
Organisation, Order, Flag
Organisation1, A, 1
Organisation1, B, 0
Organisation1, C, 1
Organisation2, D, 0
Organisation2, E, 1
Organisation3, F, 0
Organisation3, G, 1
Organisation4, H, 0
];

I want a trellis consisting of tables like:

Organisation1:
Order: A
Order: C

Organisation2:
Order: E

Organisation3: 
Order: G

My dimension in both my trellis and the chart is: Aggr(Only({<Flag={1}>} Organisaton), Organisation).

It works in that we get a trellis chart of only Orgs 1-3, but each table has all the orders with the Flag = 1. I want each table to only include one Organisation. 

I've looked into the advanced mode but have not been able to make it work. 

Could someone help me? 

[Kushal_Chawda]

@L_VN  Is there any measure you are using or just two dimensions you want in Table?

[L_VN]

In the real life scenario I also want other fields too but no measure, mainly just a bunch of dimensions.

[Kushal_Chawda · Accepted solution]

@L_VN  try below

Create a table with below calculated dimension for orders. Uncheck Include NULL values option.

=aggr(only({<Flag={1}$(vDimSet)>}Order),Order)

Setup trellis container with advanced mode on.

[L_VN]

This is done in the master visualization item. If more columns are to be added they all need to include the filtering. Thank you!

[Kushal_Chawda · Accepted solution]

@L_VN  Indeed. you need to create a same calculated dimension for all other dimensions