Columns with conditional removal of data

[psk180590]

Hello All,

I have my sample data in the below format.

ID	REG	State	Present
1	AA	100	4
1	AA	100	5
1	AA	100	6
1	AA	100	3
2	AB	110	1
2	AB	110	4
3	CR	130	6
5	VX	120	8
6	GG	160	9

I'm looking to generate 4 new Columns here:

1. Count of All Distinct ID's in the country : 9 (Should now change even when a REG or State is selected)

2. Count of Distinct ID's per State  Ex: State 100 is 4 (Should not change when REG is selected)

3. Sum of Present in the Country :46 (Should now change even when a REG or State is selected)

4. Sum of Present per State Ex:State 100 has 18 (Should not change when REG is selected)

I have attached my sample app also along with the sample data and Expected result.

Note: I want this columns to be generated in the Script not in the Application using Set Analysis.

TIA!!

[Anil_Babu_Samineni]

We have some limits in scripting. But, In fact we doesn't have concept ignore field concept in Script level. Hence, It can not be done. Can we know the reason why it is not possible in UI?

[OmarBenSalem]

psk180590‌ ; did this do the trick?

[psk180590]

Thanks much, the solution is almost perfect.

The Sum(Present) works perfectly. Only the Count doesn't seem to be satisfied yet

[psk180590]

If possible can you please share the sample app you created

[psk180590]

Made slight modifications to the script and it works perfectly. Thanks!!

[OmarBenSalem]

good to know !

[psk180590]

Hello omarbensalem

I'm experiencing some problems with particular selections in my app. If possible can you share the Test/Sample you created?

Thanks

Sai.