Have totals and % on bars

[greend21]

I'm using the barsPlus extension to get the values on the bar chart, but I was wondering if there was a way I could get the values to show percentages too. I'm assuming this would be in my expression and maybe with the dual fuction? The help page doesnt really give much detail on Dual() though. Any help is appreciated. Thank you!

[petter]

Yes you should be able to use the Dual() function for that purpose.

For example:

Dual(1/2*100 & ' %', 34) will display as 50 % while the number part will be 34 just to show that the text part can be entirely different from the numeric part of a dual value.

So in relation to to your expression it might have to look like this:

Dual( Sum(Amount) & '  ' & Num(Sum(Amount)/Sum(TOTAL Amount),'0%') , Sum(Amount) )

The only thing to be aware of is that the text part and the numeric part has to match up so that for every unique number there will be a unique text or it might not work as intended.

[greend21]

I'm trying this but it is just showing my original counts, nothing about the percentages.

Dual(Count(ReceivableID)&' '&Num(Count(ReceivableID)/Count(TOTAL DISTINCT ReceivableID), '0%'), Count(DISTINCT ReceivableID))