Filtering using expression

[chiso_chiso]

I have a crosstable with a fields called Question and Answer. I want to filter only questions with a specific word and count the number of responses.

Example, I want Overall Availability, Coke Availability, 20l Coke Availability, 40l Coke Availability seperately.

See Attached

[ashfaq_haseeb]

Now check sheet2 without drilling

Regards

ASHFAQ

[chiso_chiso]

Thanks Ashfaq

[jyothish8807 · Accepted solution]

Hi Harrison,

PFA.Hope this is what you are looking for.

Regards

KC

[chiso_chiso]

Thanks Jyothish, thats the logic I am looking for.

[jyothish8807]

You are welcome

Regards

KC