Hi All,
I have a pivot table ( as shown below). I have 2 questions.
1. how can I hide a row if I have only one child value (in case of Core Adj: G&A). In this case, I want to hide the child row (as it is repeated)
2. when I drill down to same parent value (Core Adj: G&A), I am getting multiple repeated rows (please refer below image)
I want to show only the child row (here in this case it is others.) and want to hide all parent rows ( as again values are repeated and not looking good)
Could any one suggest me how to achieve this, please .
Thanks
Gayatri