Clear selections bug

[#1]

Interacting with a pivot is fine, however when i press "Clear" the pivot does not react to any selections.  For example

Before:

Then i press either the "Clear Selections" button, or the toolbar "Clear" button and i get this after i make new selection;

[MK_QSL]

Check General tab of your Year and Quarter Listbox..

may be Always One Value Selected is Ticked... (enabled)

[#3]

Thank you for your quick response, but unfortunately no.  I checked every object to see if it was enabled.  Not one. 

[MK_QSL]

is there any Document Trigger or Sheet Trigger set up?

[Anonymous]

Maybe  you  have   selected  a field  in the  trigger

for  example:

[rubenmarin]

Hi Steven, check in the general tab of the chart the calculation condition, maybe is set to work when only one dimension is selected, not two; or is set to select two years but the text doesn't tells.

[#7]

Thanks Ruben.

You're right it has to be the Calculation Condition.  The table on top has a condition of GetSelectedCount(_dimension) >= 0 however, when i select clear all it crashes and says "Out of object memory"

the table on the bottom has the condition of  GetSelectedCount(_dimension) > 0  It was the original condition that is not working with any selections.

[rubenmarin · Accepted solution]

Hi steven please check that the Pick Dimension(s) list is using _dimension Field. if not, change calculation condition to the field used in that list.

The table on top is easy to fail when you deselect all, if it's calculation condition is GetSelectedCount(_dimension) >= 0, it will try to calculate with all the dimensions.

[#9]

Ruben you are the man!  If you were here I'd kiss you.  I can't believe i overlooked such a simple solution.

Thanks again.

[rubenmarin]

Glad to help! That kind of thanks bringing a smile is what encourage me to keep participating in community.