Pie Chart - Several dimensions must add up to a defined number

[marcouser]

Hi everyone.

I would like to create a Pie Chart with 7 dimensions:

GDP per capita	Social support	Healthy life expectancy	Freedom to make life choices	Generosity	Perceptions of corruption	Dystopia
1.34	1.587	0.986	0.596	0.153	0.393	2.714

These dimensions "GDP per capita" , "Social support", "Healthy life expectancy","Freedom to make life choices", "Generosity","Perceptions of corruption" and  "Dystopia" add up to a score, in this case

Score

7.769

The pie chart must represent the score with its parts representing the dimensions.

Combining the dimensions (GDP per capita&Social support&...) to one dimension and setting the score as Measure did not work. Is there a way to solve this? 

Thanks in advance!

[lironbaram]

hi 

what you should try to do 

is in the load script run a crosstable function so in the end the Table will look like this 

than building the chart would be easy 

[marcouser]

Thanks for your reply,  it worked!