To Show data like in percentage

[#1]

first dimension is month and second is airline .

when i drill down that  then airline wise revenue is coming .

i'm using sum(data)  expression.

i just want it will show revenue airline wise and  % share of revenue in total month revenue.

could you please help ???

like this i want to show

[#2]

HI

- Create a variable to store the % calculations

     * v% = 100*(aggr(sum(Qty),Invoice #)/sum(Qty)

- Add another expression and add the below as definition

     sum(Qty)&' ('& v% &')'

- Untick Bar in the Data option

- Tick Value on Data points

Hope this makes sense.

I have a sample file on personal edition not sure if you can open this

Note: Please check fields names match with the field names on your file

Thanks and

Padma

[#3]

please understand my question i want to  use drill down ..  and to show data firstly on monthwise dn after drill down it will show the data airline wise and its total % assosicated in month data.