Question related to Pivot Tables

If you could provide a sample of what you have so far I can try a couple of things.

Matuna,

Thank you for the offer. I am attaching a sample file (my real file is huge).

You can see that there are 5 different products for treatment of TB: products K to O.

In the pivot worksheet, however, we only count 2, since it is looking at "indicator 1". I need it to somehow count all three indicator columns, and get a count of 5.

Cheers,

Yoav