Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is there a way to suppress the + sign in a pivot table when there is nothing defined below.
I have a Pivot table and sometimes the second level is not defined but there is still a + sign on the first level.
Thank You,
As far as I know, the first dimension will always have + sign. To ignore + sign in more dimension, I would suggest you create cyclic or drill down group.
Regards
Eraaj
Maybe "Always fully expanded" option is what you need. It eliminates all +signs.
I think if we can capture a action when we click the "+" sign and write marco , maybe we can solve it, but how to capture, it's a question.