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!
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 |
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.
Still trying to find a solution to this - Is anyone able to help at all please?
Anyone able to help further please?
