how to show data in %

[#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.

want some expression like this when i will  click on month  then it will show month wise data and when i will drill down by airlines dn it should data  and percentage of share in total month data ?

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,

PFA, qvw with test data.

[maxgro]

add an expression to bar chart and only check value on data point

use num to format and total for %

num (sum(data), '#.##0') & ' (' & num(sum(data) / sum(TOTAL <month> data), '#.##0,0%') & ')'

or

num (sum(data), '#.##0') & ' (' & num(sum(data) / sum(TOTAL data), '#.##0,0%') & ')'

or

num (sum(data), '#.##0') & ' (' & num(sum(data) / sum(TOTAL <airline> data), '#.##0,0%') & ')'

[ashfaq_haseeb]

Hi,

Look at the attached application.

Regards

ASHFAQ

[suniljain]

You can use sum(data)/Sum(total data)

[#6]

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.