I want to create a simple pie chart that COUNTS (PART NUMBER) and the legend will show category by Mechanical, Hydraulic, and Electrical.
Problem is when I add "COUNTOF PART NUMBER" field to the "Values" and add "Department" to "Filters on this visual" I can only pick one item. Like I need to add "COUNTOF PART NUMBER" field to the "Values" 3 times, and have each repetitive count filter differnetly (i.e., Mechanical, electrical, hydraulic).
I've been running in circles for hours trying to create an entirely new table or new calcualted colum/field, but I just can't figure this out. Please help!
| PART NUMBER | DEPARTMENT |
| 58F-50-00101R | MECHANICAL |
| 58E-50-00501R | MECHANICAL |
| 58E3210050SERVR | MECHANICAL |
| EM8355R | HYDRAULIC |
| 94487240 | MECHANICAL |
| EM8355R | HYDRAULIC |
| PB9839 | HYDRAULIC |
| PC2575 | HYDRAULIC |
| EM9639 | HYDRAULIC |
| EM8353R | HYDRAULIC |
| 99210540R | HYDRAULIC |
| 79327973 | HYDRAULIC |
| 81325473 | HYDRAULIC |
| PB9008R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| 58B-50-40351R | MECHANICAL |
| 58B3200247SERVR | MECHANICAL |
| EM8353R | HYDRAULIC |
| 58F-41-00010R | HYDRAULIC |
| 58B-50-40351R | MECHANICAL |
| 58B3200247SERVR | MECHANICAL |
| PB9008R | HYDRAULIC |
| 58B-50-40351R | MECHANICAL |
| 58B3200247SERVR | MECHANICAL |
| 58F-50-00101R | MECHANICAL |
| 58F-41-00010R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| GE0053R | ELECTRICAL |
| PB8995R | HYDRAULIC |
| EM8844R | MECHANICAL |
| PB8995R | HYDRAULIC |
| PB8995R | HYDRAULIC |
| EM8844R | MECHANICAL |
