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 / April 2008

Tip: Looking for answers? Try searching our database.

Calculated Field based on 2 Running Totals in PivotTable

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
InfiniteJoy - 10 Apr 2008 23:33 GMT
I need to create a calculated field in a pivot table that would be the
ratio of two running totals already in my pivot table.  I would like
to avoid doing the calculation in cells outside the pivot table.

Here is how my data needs to look and I am unable to get the ratio
calculated:

Week   Running Total 1    Running Total 2            Ratio
1                2
3                            0.67
2                5                         10
0.50
3                7                         21
0.33
4               10                        40
0.25
Héctor Miguel - 12 Apr 2008 02:29 GMT
hi, !

> I need to create a calculated field in a pivot table that would be
> the ratio of two running totals already in my pivot table.
[quoted text clipped - 5 lines]
> 3                7                         21                         0.33
> 4               10                        40                         0.25

op1: see Debra's Excel - Pivot Tables - Custom Calculations:
      -> http://www.contextures.com/xlPivot10.html

op2: you will need the helper column

hth,
hector.
InfiniteJoy - 12 Apr 2008 22:54 GMT
I already know how to create the Running Totals in a Pivot Table.

I am asking how to make a calculated field from those two Running
Totals without having to resort to a helper column outside the Pivot
Table.
Héctor Miguel - 12 Apr 2008 23:39 GMT
hi, Chris !

> I already know how to create the Running Totals in a Pivot Table.
> I am asking how to make a calculated field from those two Running
> Totals without having to resort to a helper column outside the Pivot Table.

you never "show" to us how your PT layout looks-like (so, just in case)...
if you have only 2 "data-items" in a "2 rows arrangement" PT    -?-
be sure your PT layout is (or can be) accomodated like this one:
-> Excel - Pivot Tables - Data Field Layout
   http://www.contextures.com/xlPivot02.html

now, you will be able to add/formulate/... your custom calculated field

if any doubts (or further information)... would you please comment ?
regards,
hector.

Rate this thread:






 
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.