Same column with different condition in different sheets

[jalpashukla]

Hello everyone,

I have four sheets in my app which are working as below:

sheet-1: where project status = active, feedback <> 0 , country = india

sheet-2: where project status = active, feedback =0, country = india

sheet-3: where project status=active, feedback <=3, country = india

sheet-4: all data

Sr.no	product	Project status	feedback	Country
1	ABC	Active	1	India
2	ABC	Active	4	India
3	ABC	closed	0	Paris
4	ABC	not applicable	4	France
5	ABC	closed	1	India
6	ABC	Active	0	India

If I select "Product"=ABC from any sheet, the result should be visible with respective conditions.

Expected result:

sheet-1:

Sr.no	product	Project status	feedback	Country
1	ABC	Active	1	India
2	ABC	Active	4	India

sheet-2:

Sr.no	product	Project status	feedback	Country
6	ABC	Active	0	India

sheet-3: 

Sr.no	product	Project status	feedback	Country
1	ABC	Active	1	India

@PrashantSangle @avinashelite  @swuehl @kaushiknsolanki @MK_QSL @vikasmahajan @Chanty4u @Anil_Babu_Samineni @Kushal_Chawda  @sunny_talwar 

Thanks

[SerhanKaraer]

Hello Jalpashukla,

You can filter model by using a measure and set analysis, which is equal to where condition in your requirement.

For your first sheet, you can use feedback as a measure with expression Sum({<[Project status]={"active"},feedback=-{"0"},Country={"india"}>} feedback) to filter the table.

Similarly,

for second sheet Sum({<[Project status]={"active"},feedback={"0"},Country={"india"}>} feedback)

for third sheet Sum({<[Project status]={"active"},feedback={"<=3"},Country={"india"}>} feedback)

[jalpashukla]

I dont want sum of feedback.. I just want to apply the condition on whole table. If I apply on dimension, the condition becomes part of filter while selecting any value from table.