how to show data in %

[#1]

hi i have a bar graph in drill down .

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

[alexandros17]

try this

Sum(data) / Sum(total <month> data)

let me know

[#3]

no this is not the solution.

there should be some expression that will show data and percentage..

as u r seeing in graph i showed.

[#4]

please help?

[MayilVahanan]

Hi

Try like this

= Sum(Total1) & '  '& Num(Sum(Total1) / Sum(total [Total1]),'#.##%') &''

[alexandros17]

So your problem is not How to compute but how to show value and percentage

If this is correct, I tell you that this is not possible because you have no control on value on data points ...

[#7]

both are my problem ..  this is not working

[alexandros17]

Could you send your document?

[#9]

Hi ,

Any  solution for this ??

[its_anandrjs]

Use Dual function for this. See with small example to understand

Load * inline

[

Customers,Sales

Ghanna,152450

Jersey,154702

Newzealand,45826

];

And on the chart

Dimension:- Customers

Expression:- Sum(Sales)

Expression:- Dual( Customers & ' - ' & sum(Sales),

                               Sum(Sales) / Sum(TOTAL  Sales)  )