i have a dashboard that uses many expressions to filter a list of items in pivot table. The problem is when i go to print the report to many blank pages appear in the report. What i did was create a filter to remove the 0's and blanks. But the problem is the data will change so i can't create a bookmark to loop in report printing. I need a way to select all in a pivot table, listbox or anything to put as a bookmark button, so users can just click the button and everything will be filtered for them for print. I can't edit the script of this dashboard!!
Thanks a lot