Pie chart from Pivot table

[konidena]

Hi Team,

Here is my sample data.

	ABC			BCD			DEF			Total
Product	Target	Sales	Ach%	Target	Sales	Ach%	Target	Sales	Ach%	Target	Sales	Ach%
A	10	22	2.2	10	22	2.2	10	22	2.2	30	66	6.6
B	20	33	1.65	20	33	1.65	20	33	1.65	60	99	4.95
C	30	34	1.133333	30	34	1.133333	30	34	1.133333	90	102	3.4
D	40	41	1.025	40	41	1.025	40	41	1.025	120	123	3.075
E	35	32	0.914286	35	32	0.914286	35	32	0.914286	105	96	2.742857
F	21	22	1.047619	21	22	1.047619	21	22	1.047619	63	66	3.142857
G	22	25	1.136364	22	25	1.136364	22	25	1.136364	66	75	3.409091
H	18	19	1.055556	18	19	1.055556	18	19	1.055556	54	57	3.166667
I	21	22	1.047619	21	22	1.047619	21	22	1.047619	63	66	3.142857
Total	217	250	11.20978	217	250	11.20978	217	250	11.20978	651	750	33.62933

This is my sample data.  I need to create the Pie chart for the Ach% column belongs to the "Total" marked under red color.

ABC, BCD, DEF are the teams. Row wise , for each product the Ach% is some products it is 45%, 46%. for some products it is 151%, 120%. As a total is showing 27% . To describe the place of the value i made the number in blue color here.

Please suggest how to make pie chart for the Ach% column. Also, the pie chart should show Ach% and Balance Ach%.

Regards

Srinivas

[Anonymous]

Hi,

You can make the teams and product as dimensions. Change the chart to a pie chart. in the expression, you can have something like avg(Ach). This will only get the value that you want for the Ach which will be one value.