Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternative way to change data in Pivot Table
Hi,
Unlike normal tables, we can't change the data in a pivot (ie total clients in a city). If I double click on a particular figure, it will bring me to a new tab with all the details listed. If I try to delete, it saysthat I can't change this part of a report. Let's say my data is down to the city level and the user is able to play with the pivot and choose different grouping level (ie state/Country). Anyways, I only want to allow the user to change the number of clients of a city. Thus one criteria to check is to ensure the user is trying to make a change to a city and not a state/country. There's also other info about the cities, but the change is only allowed to the number of clients field. What can I do? Thanks, Carmen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i change pivot table to change data | Excel Discussion (Misc queries) | |||
change data source of pivot table | Excel Discussion (Misc queries) | |||
Why do my outlines change on my pivot table when I add new data? | Excel Programming | |||
Change Data In Pivot Table | New Users to Excel | |||
Change to SQL of Pivot Table on shared data | Excel Programming |