Block chart labels: Show number and percentage

[ljdlumley]

I have a feeling this should be simple but just can't find the answer. I have a simple block chart counting the number of students on each course. I have the expression set to Relative and have ticked the 'Show Numbers with labels'

What I would like to do is show, in the block, the percentage and the number that represents e.g. History (12.5%, 45) I can only get one of these to show at a time. I tried the same method you'd use with a pie chart, using a second identical expression but the only 'Display Options' that can be changed is 'Text as Pop-up'

Can anyone tell me if it is possible to show the value and the percentage this represents in a block?

thanks

John

[Clever_Anjos · Accepted solution]

The trick way is create a dual expression

For example

=dual(

  'Value:' & sum(Value) & chr(10) & '% = ' & sum(Value)/sum(total Value),

    sum(Value)

)

It´s important to *not* format at "Numbers" tab, mark it "General"

[yakir_manor]

you can just mark 'Show Numbers with Labels' in:

Chart Properties -> Presentation

totally solved it for me (: