Theusersrequirementis as follows. We have two dimensions (concept 1 and concept2) in a pivot table chart. They want to hide the rows when the second dimension has only one occurrence, and keep the total in the first dimension:
ACTUAL RESULT is the result that I have at the moment.
Concept 1 and Concept 2 are two dimensions. Concept 1 is the first dimension (bold font style) and Concept 2 the second one (normal font):
SPECTED RESULT is that I want to get. I want to hide Concept 2 when it has only one row, i.e: Concept 1 'Machines and Accesories' has only one ocurrence in Concept 2, then I don't want it apears in the table. Concept 1 'ITIS' has two ocurrences in Concept 2 ('Hardware' and 'Maintenance'), then they sould be present in the table: