Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 parameters: Region and Company, and one Revenue to show the result.
If I select one of the items in Region, the Sheet will show the relevant Revenue in the text object.
What I want is: I want to choose the items in the Region and the items in the Company, during this time, the Revenue are not changing. After Choosing finished,
the use one button to refresh the relevant Revenue, is it possible?
Thanks.
I know what you want as I had to do this to improve performance.
create a variable that called vDisplay and set it equal to 1.
create a button that will alter vDispay = -vDisplay (I also put a color condition on button to green when vDisplay =1)
Go into your revenue chart, set a calculation condition on first page vDisplay=1.
Go to error messages, set the calculation condition unfulfilled to say something like "Click the button when you are done making selections and are ready to display the results."
I actually labelled the button 'Dynamic mode' and it was green when vDisplay=1.
This significantly improved the performance of my Outpatient dashboard with 600 million records in it. Basically, it only takes one multiselction refresh when selecting from many parameters vs. 1 to 10 dimension refresh updates. Similar to bookmarking, but when different dimensions would be selected.