View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve D Steve D is offline
external usenet poster
 
Posts: 22
Default 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