Forum Discussion
Sum in chart
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
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?
1)Dimension is country
2)everything is in one table
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!
/ Jwill it populate like 37.4 (KPI) value in chart and which column to be added like in dim and fact in your case
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