How to create data visualizations that 'show' the "is a" value?

[KevinL194086803]

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?

[shubhamseth · Accepted solution]

@KevinL194086803  can you try using multiple data sources within same pivot table visualisation if that helps. 

[KevinL194086803]

That did the trick!  Thanks for the assist on this one!

Output references for anyone who comes looking in the future for how it was accomplished.

 

 

--Kevin

[shubhamseth]

Hi @KevinL194086803 I am glad that it helped you! Great! 

Appreciate your efforts in putting snapshot of outcome for others to refer if needed.