Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Pivot Table report
Hi,
I am new to Pivot Tables. I have a large worksheet which I named 'Master List' and want to create 2 reports from this list - "Status" as Active and the other as Closed. My intention was that when an account Status changes on the Master List from 'Active' to 'Closed', the Pivot Table would remove the account from the 'Active' Pivot Table report and show it on the 'Closed' Pivot table report. On 1 account, I changed the Status from Active to Closed, and even though I saved the file with the change, then refreshed then Refreshed Data on the Pivot table, the account in question remained on the Active report. Is there something I am doing wrong, or once the Pivot Table is created, the data is not 'removed' from the report? -- Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"A pivot table report cannot overlap another pivot table report" | Excel Worksheet Functions | |||
pivot table report | Excel Discussion (Misc queries) | |||
A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) | |||
Pivot table report | Excel Worksheet Functions | |||
pivot table report | Excel Worksheet Functions |