Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
Sum(data) / Sum(total <month> data)
let me know
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.
please help?
Hi
Try like this
= Sum(Total1) & ' '& Num(Sum(Total1) / Sum(total [Total1]),'#.##%') &''
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 ...
both are my problem .. this is not working
Could you send your document?
Hi ,
Any solution for this ??
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) )