% Value in Cross Tab

[kutoose]

I need to create a report which is having this requirement

It should give the % of generic drugs per store

There are three types of Drugs, Gereric,Brand and Single


The report format is like this
Store1 Store2 Total
Week1 a% b % c%
Week2 x% y% z%




The percentage is for GENERIC drug only.

I think I will be using Cross Tab and I know how to get 'Week Rows'. I don't know how to get the column values which calculate the percentage of Generic Drug.

Thanks !