this trigger is one the dimension level and not sheet/report level, so the trigger will be executed each time to click on this dimension.
can you tell me more what are you trying to do maybe there is a better way to accomplish it besides using a trigger? maybe upload a sample document.