Load data after filtering
The pivot table loads all the data everytime we view the dashboard.
Is there any way I can not load the data, but just the filter, and after the values have been filtered and the user clicks GO only then should the data be shown.
This will improve the performance by leaps and bounds.
Is there any pivot table or dashboard property that allows this?
Can I used guided navigation or something to implement this?
thanks for the help.