Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2006

Tip: Looking for answers? Try searching our database.

Pivot and comparison with fixed values

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
juma68 - 14 Jun 2006 09:09 GMT
How to compare some fixed numbers with pivot numbers ? In details:
- I have some allocations = volumes to sell = my plan = fixed numbers
- I have a pivot which retrieves data from mainframe automatically =
fulfilment
- I need to put numbers of my plan and numbers of fulfilment together =
see down

Product    SalesGroup    Month1            Month2            Month3 etc

pencils     SG1               plan10_real8    plan12_real10
              SG2               plan15_real12

I know I can´t input any number into pivot table but how to solve it ?
Pls give me some
idea to compare numbers which are on a paper close each other to have a
nice
excel dashboard report fro executive / nobody likes to look once plan
left and reality right

Any advice is highly appreciated

Juraj
Debra Dalgleish - 15 Jun 2006 01:19 GMT
Perhaps you can set up a table with your plan numbers, then use the
GetPivotData function to pull data from the pivot table. There's
information in Excel's Help, and here:

  http://www.contextures.com/xlPivot06.html

> How to compare some fixed numbers with pivot numbers ? In details:
> - I have some allocations = volumes to sell = my plan = fixed numbers
[quoted text clipped - 18 lines]
>
> Juraj

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.