Hello Ram -
In this case you can just use your right mouse click and drag to drop the pills on a shelf. click on the top option when this box pops up.
And you will want to right click on the pill in the shelf and 'convert to discrete'.
This works for your workbook. For more complex workbooks you can always explore level of detail calculations.
Hope this helps.
Thanks a lot john