I am trying to build a dashboard prompt for Account Owner Organization, I am able to get the account owner and I have been trying different SQL and Case If for the prompt to work but no luck.
I tried to add resource Primary organization name but it defaults to the opp owner instead of the account owner.
Any thoughts?