Sum in chart

[Anonymous]

Hello Expert,

How to get Sum  number in charts like highlighed in below mentioned screen. Help with the step

Shree

[tex628]

Change the postition option on your graph to "inside end" in the data labels options.

[Anonymous]

Thanks..

This is data label. How   37.4 value we can be added in chart

Shree

[tex628]

Sorry i missunderstood. 37.4 can be added but its quite complicated.
What is the legend dimension that you are using?
Is everything in one table or do you have dimension tables?

[Anonymous]

1)Dimension is country

2)everything is in one table

[tex628]

This would require you to change your datamodel, but what you would need is something like this:



By creating double crossfilter relationships between these three tables you can get a "Total" value in your country dimension that is mapped to all of your countries. This should give you the result you are looking for!

/ J

[Anonymous]

will it populate like 37.4 (KPI)  value in chart and which column to be added like in dim and fact in your case

[tex628 · Accepted solution]

This will result in you 37,4 value appearing in the chart as a new column. You need to use the country column from the country table as it is the only one that has the Total column value!

/ J

[Anonymous]

Hi,

it is showing as column in chart ..i want this kpi to be populated along with chart

Shree

[tex628]

You just want the number and nothing else?

[Anonymous]

Along with bar chat that number should display

[tex628]

In the same visual or with two seperate?

[Anonymous]

same

[tex628]

It's not possible. The closest you can get is adding an average if you're working in percent: