values on data points query

[hopkinsc]

hi all, is there a way i can get the full value showing on my data points but have the scale only showing the reduced numbers.

i.e.

my values are in the millions, so the full number on data point (77,000,000) but the scales just showing 10 20 30 40 50 60 70 80 etc

I have attached an example

thanks

[simospa]

Hi,

try to remove in Number --> Thusand Symbols and Million Symbol the label £ Thousands and £ Milion.

S.

[hopkinsc]

Hi, thanks, if i do that then the scale will show the full value also. i want the scale to remain as it is

[ganeshreddy]

Hi,

PFA ....please find the solution there. this is how you can represent in this situation.

if you find its the answer, please mark it as correct answer

[hopkinsc]

Hi, thanks, its useful but not the answer i'm afraid.

i need the full value displayed on the end of the bars. i can get this if i remove the symbols from the number tab but that impacts the scale too.

my client has just upgraded from v9. in v9 this was possible but it doesnt seem possible in v11.2

[ganeshreddy]

Hi ,

This post is extension to the above post. you can mark values plot inside option form presentation tab. PFA

[Anonymous]

1. Add a second expression as shown in image below,

[hopkinsc]

hi, thanks. this is something i have already tried. it doesnt give the total, it give the value of the last segment in the bar.

i need it to show the total value of sum(Sales).

i.e.

UK = 52,000,000

US = 77,000,000

Thanks

[Anonymous · Accepted solution]

try this expression then,

sum(total<Country>Sales)

[ganeshreddy]

hi Hopkinsc,

PFA. this file may may help to achieve your task. In exp tab see total expression.

cheers,

Ganesh