Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I am trying to use get pivot data with variable criteria
I have a presentation report which uses the getpivotdata function to retrieve
information from a pivot table of vendor transactions. I need to be able to run the report for each vendor individually, but I do not want to set up a separate report for each of them. I have tried using various other functions within getpivotdata( eg cell(),concatenate(),cell reference instead of text), none of them work. It seems to only accept specific text. Is there a way around thisplease? |
#2
|
|||
|
|||
You can use cell references in the formula. There's an example he
http://www.contextures.com/xlPivot06.html JenS wrote: I have a presentation report which uses the getpivotdata function to retrieve information from a pivot table of vendor transactions. I need to be able to run the report for each vendor individually, but I do not want to set up a separate report for each of them. I have tried using various other functions within getpivotdata( eg cell(),concatenate(),cell reference instead of text), none of them work. It seems to only accept specific text. Is there a way around thisplease? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Pivot table of data in more than one worksheet | Excel Discussion (Misc queries) | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |