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]

Welcome

[chiso_chiso]

One more thing, how do I filter 2 words from the same field e.g. Availability, 20l and coke using the attached example.

[ashfaq_haseeb]

Hi,

I have seen attachment, its not clear.

Can you explain a bit more?

Regards

ASHFAQ

[chiso_chiso]

Thanks Ashfaq,

I want the total for Availability, then drilled down to Total Availability of Coke (as brand) and Total Availability of 20l(as SKU). If possible in one chart.

Regards

[ashfaq_haseeb]

Hi,

May be like this.

Check Sheet1 in attached application

If it answered then mark it as helpful.

Regards

ASHFAQ

[chiso_chiso]

This is very helpful. Please explain it.

[ashfaq_haseeb]

Hi,

If you see attached excel I have added new field called Map to map all Availability, Visibility and Spacing in 1 group.

In fronted I have created a drill down group which fill first show total availability when you click on it it will drill to all available SKU's

Hope it helps

Regards

ASHFAQ

[chiso_chiso]

I see.. But isnt there a way of filtering using an expression like 'if question has a word availability and coke, then count'

[ashfaq_haseeb]

We can but that will not allow you to drill.

Regards

ASHFAQ

[chiso_chiso]

Please explain, and leave out the drilling.