Can I create a chart from a summary table?
Is it possible to create a pie chart with totals of the whole. I know it is possible to create a summary of a table to create totals. How can I use those totals to create a Pie Chart?
Forum Discussion
You should be able to just create summary fields or formula fields to get your totals in a field. Then create a chart and use those values.
Hey Chuck thanks for all your help thus far.
I have a table where each row represents a school and a count of disabilities in that school.
Then I wanted to aggregate the number for each column; I want to create a pie chart with values Sum(deaf), Sum(blind), .....
So I can see as a how disabilities _compare to the whole. School doesn't matter, just want to add up disability groups/
I have a table where each row represents a school and a count of disabilities in that school.
id school deaf blind ..etc 1 New York University 3 4 ... 2 Georgia State University 5 2 ...
Then I wanted to aggregate the number for each column; I want to create a pie chart with values Sum(deaf), Sum(blind), .....
So I can see as a how disabilities _compare to the whole. School doesn't matter, just want to add up disability groups/