Formulas based on Pivot Table
I believe this is possible but I can't remember how I did it in the past...
I have a pivot table that has formulas to the right and depending on the
filter I use I can have anywhere from 5 rows of data to 30,000 rows. How can
I have the formulas only appear where there is data? So if I have 5 records I
would have 5 rows of formulas and if I have 30,000 records I would have
30,000 rows of formulas.
Is this possible?
--
Thank You,
Steve
|