PC Review


Reply
Thread Tools Rate Thread

Alternative way to change data in Pivot Table

 
 
=?Utf-8?B?Q2FybWVu?=
Guest
Posts: n/a
 
      18th Mar 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
can i change pivot table to change data =?Utf-8?B?amFjb2IyMg==?= Microsoft Excel Misc 2 11th Apr 2007 03:32 PM
change data source of pivot table =?Utf-8?B?Sm9obkg=?= Microsoft Excel Misc 9 15th Sep 2006 12:52 AM
Change Data In Pivot Table =?Utf-8?B?Sm9obiBDYWxkZXI=?= Microsoft Excel New Users 1 7th Jul 2005 10:41 PM
Change the data source of a pivot table Kevin Dai Microsoft Excel Discussion 1 20th Jun 2005 10:40 PM
Pivot Tables - change flat file data from the pivot table Mark Microsoft Excel Worksheet Functions 2 18th Nov 2003 08:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:28 AM.