Multiple column values into Pie Chart

[jacek27031]

Hello Community,

I am trying to create a pie chart that shows the sum of each A-G column. How can i show the values of each column in the same pie chart??

Dataset - Table3

Expected result:

[anat · Accepted solution]

can u try using the crosstable,

u will get 2 fields like desc,amount

then in pie chart use desc as dim and sum(amount ) as measure

[jacek27031]

thanks @anat; is there any other way eg. using valueList?