My columns are like below. totally 15 columns.
Country, Centre, Category, Jan, feb, mar, …, Dec. All the columns of the month name has values.
I have created pie chart, showcasing the fileds of Jan-Dec. Money values. I need to create a pie chart based on Country. Country wise, what is my expense across the year (Jan to Dec). Can someone pls help on this ?
I am using: Elastic search as datasource.