Working on some reports for leadership and trying to keep data rolled up to a high level (See example below). Would like to create a data visualization - hopefully in a pivot table - that allows me to show by row each customer and the count of these values:
- Is a Server
- Is a Database
- Is a (an) application
- Is a Network Gear
No issue building report queries in this fashion, but getting the report to render at those top level buckets is what I'm after. Trying to figure it out through either PA or the legacy Core UI reporting and coming up short.
Not rocket science in concept, but not sure I'm finding the right way to use the "is a" classification as the data aggregation layer.
| | Applications | Databases | Network Gear | Servers |
| Customer A | # | # | # | # |
| Customer B | # | # | # | # |
| Customer C | # | # | # | # |
| Customer D | # | # | # | # |
Any ideas?
