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

[ajaykakkar93]

hi,
backend script:

data1:
//step 1
load Srno,product,Project_status,feedback,Country;
load * Inline [
Srno,product,Project_status,feedback,Country
1,ABC,Active,1,India
2,ABC,Active,4,India
3,ABC,closed,0,Paris
4,ABC,N/A,4,France
5,ABC,closed,1,India
6,ABC,Active,0,India
];

exit Script;

add measure with all dimensions u need with a below measure respectively

sheet-1: where project status = active, feedback <> 0 , country = india
sheet 1 exp : Count({<Project_status={'Active'},feedback-={'0'}>} 1)

sheet-2: where project status = active, feedback =0, country = india
sheet 2 exp : Count({<Project_status={'Active'},feedback={'0'}>} 1)

sheet-3: where project status=active, feedback <=3, country = india
sheet 3 exp : Count({<Project_status={'Active'},feedback={"<=3"}>} 1)

[ajaykakkar93]

hi,
backend script:

data1:
//step 1
load Srno,product,Project_status,feedback,Country;
load * Inline [
Srno,product,Project_status,feedback,Country
1,ABC,Active,1,India
2,ABC,Active,4,India
3,ABC,closed,0,Paris
4,ABC,N/A,4,France
5,ABC,closed,1,India
6,ABC,Active,0,India
];

exit Script;

add measure with all dimensions u need with a below measure respectively

sheet-1: where project status = active, feedback <> 0 , country = india
sheet 1 exp : Count({<Project_status={'Active'},feedback-={'0'}>} 1)

sheet-2: where project status = active, feedback =0, country = india
sheet 2 exp : Count({<Project_status={'Active'},feedback={'0'}>} 1)

sheet-3: where project status=active, feedback <=3, country = india
sheet 3 exp : Count({<Project_status={'Active'},feedback={"<=3"}>} 1)