I Think you have used dimension also
In my case i need to show 3 separate columns total values
like sum(logistic cost) 35%
sum(wherehouse cost) 25%
sum(testing cost) 40%
Sorry, I did not understand your question to begin with, this is not possible with Pie Charts.
If you have access to write custom sql for the datasource, you can transform the columns to rows to end up in a table that you can use in the Pie Chart.
If you are not too attached to Pie Charts, maybe you can use 100% stacked bars?
Hi @vinodkumarb,
I’m going to go ahead and mark Andres’ comment as the solution but if you have any additional questions, feel free to create a new topic for discussion.