Hi,
I have a PivotTable with a filter on it. When the user selects an option from the filter, the PivotTable will change in size, from a minimum of about 4 rows, to a possible 40 rows.
I have a table directly below it which uses 'getpivot' formulas to perform a few simple calculations.
I would like the table to start directly below the PivotTable, and move up and down depending on the number of rows that the PivotTable occupies.
Is this possible?
Thanks in advance!
I have a PivotTable with a filter on it. When the user selects an option from the filter, the PivotTable will change in size, from a minimum of about 4 rows, to a possible 40 rows.
I have a table directly below it which uses 'getpivot' formulas to perform a few simple calculations.
I would like the table to start directly below the PivotTable, and move up and down depending on the number of rows that the PivotTable occupies.
Is this possible?
Thanks in advance!