How to calculate the counts in Pivot table

[#1]

Hi All,

I have a  below requirement .i have to calculate count of ID's ,in two different expressions.

1)First expression should have only Count of ID's ,whose ST value is only Nursing Unit Reporting group.

2)Second expression must have count of ID's ,those having the ST values Nursing Unit Reporting Group and Quality of Food Service .in this expression, those Id's having only quality of Food service are not required.

[Anil_Babu_Samineni]

May be this?

=Cound({<ST = {'Nursing Unit Reporting Group'}>}ID)

=Count({<ST = {'Nursing Unit Reporting Group','Quality of Food Service'}, ID-= {'5','28'}>}ID)

[#3]

I have  so many iDs are there,which is having only ST as Quality of Food Service.

should i mention all id's  manually in the  expression?

=Count({<ST = {'Nursing Unit Reporting Group','Quality of Food Service'}, ID-= {'5','28'}>}ID)

[Anil_Babu_Samineni]

Till how many ID's you have to exclude?

[#5]

Currently i have 3000 ids to exclude.it may change also, if i load full data.

[Anil_Babu_Samineni]

I am out of memory, stalwar1‌ marcowedel‌