Pie Chart with Sum totals

[marsbar]

Hi all

I have a table with various rows of prices in 3 separate columns. I would like to know how to create a sum of each of the three columns then show these as an overall percentage (eg. Col 1 = 10, Col 2 = 30, Col 3 = 60 then there would be a Pie consisting of 10%/30%/60%).

I have managed to get a Date Filter form to work to filter a slice but after that I can not seem to get the data to sum together and then feed into the Pie.

Please help!! Thanks in advance!

[Marc_Dillon]

---

@marsbar wrote:

I have a table with various rows of prices in 3 separate columns.

---

I would say that's probably a poor data structure design. Instead of:

Price 1	Price 2	Price 3
11	22	33
44	55	66

You should do:

Price Type	Price
1	11
2	22
3	33
1	44
2	55
3	66

[marsbar]

Hi Marc, Sorry my replies don't seem to be working on here (apologies if this has sent a few times!)

The table has thousands of rows and lots of columns, but I only need to sum 3 of the fee ones (separately) to show in the Pie. Ive mocked up a similar table to show the kind of thing Im using, Ive added the total row for reference.

This is what I was hoping to achieve (I know - its always easier in excel!!):

 

The final thing is that these are filtered by date using a date filter form which works on a slice... this would also need to be utilised still please.

Thanks again and please let me know your thoughts.

[marsbar]

Still trying to find a solution to this - Is anyone able to help at all please?

[marsbar]

Anyone able to help further please?