More options on Pivottables

  • Thread starter Thread starter libertyforall
  • Start date Start date
L

libertyforall

I am using pivot tables with some success. I think I can shorten my
work even more if I can find a way to duplicate one of the filters and
post it in successive columns. I am filtering the temperature for
specific date and times. I would like to use the pivot table to run
the temp average for all times at once instead of just one time. How
can I do this?
 
I am using pivot tables with some success. I think I can shorten my
work even more if I can find a way to duplicate one of the filters and
post it in successive columns. I am filtering the temperature for
specific date and times. I would like to use the pivot table to run
the temp average for all times at once instead of just one time. How
can I do this?
Click to expand...

Hi,

I'm not exactly too sure what you are after so if you could send some
more details that may help, but briefly....

If the filters are of your row or column members then you wont be able
to duplicate the filter
If you are filtering on a measure (value) then you could use a pivot
formula to duplicate the value and filter on that .

hth

David
 
Back
Top