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
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!
/ J
will 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!
/ JHi,
it is showing as column in chart ..i want this kpi to be populated along with chart
Shree