1 of 1 people found this helpful
I noticed that the Time worksheets had fields on Rows and Columns while the KPI worksheets did not. By using a placeholder header field on Rows for the the KPI worksheets the Profit KPI and Sales KPI shrink the same as the Time worksheets. See the steps below and attached workbook.
- Create a new calculated field with 'header' as the formula (named "Placeholder Header" in the sample workbook)
- Place the new Placeholder Header field on Rows for the Profit KPI and Sales KPI worksheets
- Right-click Placeholder Header and de-select Show Header
Let me know if this is what you are looking for!
Yes, this accomplishes exactly what I was looking for. Thank you very much!