I have added an extra column to a pivot table to analyze the results. The
pivot table is set up with a page filter for separate users. Each user can
select their data to review without having to look at the entire data set
which is 240 pages. I have used if statements so that the formula rin the
added column runs only if there is data. However if the user selects page
preview they still think their report is 240 pages long because of the
formulas in the added column. Is there any way to avoid this?