If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter Pivot Table?
You could add a field to the data source, to calculate if each record
meets the criteria. For example, if units sold is in column E, create a field with the heading 'Show', and enter the following formula: =E2=Pivot!$J$1 On the Pivot sheet, in cell J1, enter the x value, then refresh the pivot table. Add the 'Show' field to the PivotTable page area, and from the dropdown list, select 'TRUE' Yo wrote: I have a page field with currency between 100,000 and 1,500,000. I would like to be able to filter the list to show values x, where x is a number I determine after the pivot table is created. It appears that the page field is unable to accomodate me. Is there another way to accomplish this? Thanks in advance, Yo. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#2
|
|||
|
|||
Filter Pivot Table?
Thanks... Also, that was a great guess about the column the units sold was
in. Yo. "Debra Dalgleish" wrote in message ... You could add a field to the data source, to calculate if each record meets the criteria. For example, if units sold is in column E, create a field with the heading 'Show', and enter the following formula: =E2=Pivot!$J$1 On the Pivot sheet, in cell J1, enter the x value, then refresh the pivot table. Add the 'Show' field to the PivotTable page area, and from the dropdown list, select 'TRUE' Yo wrote: I have a page field with currency between 100,000 and 1,500,000. I would like to be able to filter the list to show values x, where x is a number I determine after the pivot table is created. It appears that the page field is unable to accomodate me. Is there another way to accomplish this? Thanks in advance, Yo. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|