Pie Chart Help
I have a list of "Project Types". Attached is a summary report of this table and field. But, I really want to show it in a Pie Chart. Specifically, I want "Commercial EPR New Build and "Commercial...
Forum Discussion
So in the end do you just want a pie chart with 2 slice, one labeled New Build, and a 2nd labeled Other?
If so, I would make a formula text field called [Type Simplified] with a formula:
If([Type]="Commercial NewBuild" or [Type]="Commercial EPR NewBuild", "New Build", "Other".
Then just make a pie chart using the [Type Simplified] Field.