Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using Pivot Table, Charts etc in my App.
On Clicking CLEAR button, Every object is getting cleared.
Pivot table is not getting collapse.
I think, by default it should collapse on clicking. Don't know why.
Can anyone help me with this ?
Regards,
Praveen
I think if you clear your selections the pivot table returns to the previous level of expansion before you made the selection
Hi Adrian,
Its not happening. That's my issue.
Do you have 'Always Fully Expanded' ticked in the Presentation tab?
by clicking on CLEAR button, pivot table will not collapse or Expand.
U have to right click pivot table and use Expand All or Collapse All
Adrian,
No. I have not selected that option. If that is the case, I wont be able to Collapse even manually ryt ?
Initially while opening the dashboard, it is in collapsed state only.
But after selecting it and expanding it, once if I click CLEAR, all objects are resetting except Pivot table.
If you want pivot table to collapse on clicking on CLEAR button, then create 2 pivot table display one with variable, after viewing once u click on CLEAR assign a variable to bring the other pivot table whcih is collapsed.
It is a work around ...
Thanks Nagaraj.