How to import Perfmon logs into a SQL Database to create Excel Pivot Charts
First published on MSDN on Nov 28, 2017 Authored by Edwin HernandezWe came across a scenario where a customer needs to run a Performance Test of an Application but due to security policies, customer is not able to provide Server-Level access to the Servers where the Application is hosted.
Hiding useless sub rows in pivot hierarchy without changing the calculation
Hello, I have the following issue with excel pivot: When I have a table with projects, sub projects and sub sub projects: and create a pivot table, it looks like this: When i try to hide the "(empty)" rows, pivot removes the whole row, so all that's left is the row that doesn't have any "(empty)" values in "Main Project", "Sub Project" or "Sub Sub Project": But what I actually want is the following: I don't want to filter data, I just want to hide hierarchy levels, when they are not needed. I am using SQL Server data and VBA with the copyfromrecordset method. I would prefer a simple solution without VBA or SQL Server but if there is a way with VBA or SQL Server to fix this hierarchy problem in pivot tables, it would be perfectly fine too. Thank you very much for your help and best regards.
