T
Tami
ok, so i'm new to getpivotdata but it seems to be working....i run the pivot,
its on the left side of the sheet, then i have a summary table that presents
the data in an easier fashion to read. In my example, i have a vendor
summary so it summarizes for all 10 classifcations what the $$ receipts are
by vendor. But if the user sets the drop-down filter on the pivot to just
two of the 10 classes then my getpivottable updates But you have no idea that
the data is for only class xxx and yyy. does that make sense?
is there a way to show the class filter....
or can the filter pull from a list or
can i write by getpivot formula to pull from a list of classes (and that
list could be in the print range)
its all about making sure that the summary that is pulling from the pivot,
clearly indicates what classes are included.
hope this makes sense...
tami
its on the left side of the sheet, then i have a summary table that presents
the data in an easier fashion to read. In my example, i have a vendor
summary so it summarizes for all 10 classifcations what the $$ receipts are
by vendor. But if the user sets the drop-down filter on the pivot to just
two of the 10 classes then my getpivottable updates But you have no idea that
the data is for only class xxx and yyy. does that make sense?
is there a way to show the class filter....
or can the filter pull from a list or
can i write by getpivot formula to pull from a list of classes (and that
list could be in the print range)
its all about making sure that the summary that is pulling from the pivot,
clearly indicates what classes are included.
hope this makes sense...
tami