Pivot Table problem,
 

Hi,
I have a PT with data in a text file.
I've learned that you can do wonderful things with the Value display options
in a PT but I'm wondering if I'm asking too much and if I need to
a) add in some calculated values
b) go back and add some stuff to the underlying data in the text file.


I have a .gif picture here that explains it all.

http://www.fransysco.net/frogs/frogs2.gif

TIA

M.G.

Pivot Table problem,
 

Hi,
for calculated values, right click the field - select field settings -
options - select "difference from" and select the base items
To add data, it is best to use "Dynamic ranges"
You can find info on both solutions at 'Excel -- Pivot Tables -- Custom
Calculations' (http://www.contextures.com/xlPivot10.html)
and 'Excel -- Names -- Naming Ranges'
(http://www.contextures.com/xlNames01.html#Dynamic)


Michel Groff;284280 Wrote:
Hi,
I have a PT with data in a text file.
I've learned that you can do wonderful things with the Value display
options
in a PT but I'm wondering if I'm asking too much and if I need to
a) add in some calculated values
b) go back and add some stuff to the underlying data in the text file.


I have a .gif picture here that explains it all.

http://www.fransysco.net/frogs/frogs2.gif

TIA

M.G.


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79400

Pivot Table problem,
 

Hi,
thanks for the reply,
(I haven't been to the site yet.)

The problem is that I have the Died
But I need the Still Alive.
The Delivered is the Total of the Died.
So for each semester I need to subtract the Died from the Delivered to get
the Still Alive.

-------
You advise,
select "difference from" and select the base items

I know about that, and have done it before, but I don't think there is a
valid base item.
I need Delivered but Delivered doesn't exist in the record structure as a
data item.
It's a total of Frog ID Count.
And Frog ID Count doesn't really exist either as it is a Count of Frog ID.

Each line in the data file has a
Frog ID and a Semester ID (for last sign of life)

Excel "adds in" a Count of the Fog IDs.
So we now have
Frog ID; Frog ID Count; Semester ID

AFAICS
To calculate the Still Alive, in each line, I need to have a handle on
Total of the Frog ID count (= Delivered) to be able to subtract the Died.

Can Excel do this without first getting the Total of the Frog ID count (=
Delivered) into each line ?

I will now skip on over to
(http://www.contextures.com/xlPivot10.html)

MG





"Pecoflyer" a écrit dans le message de
news: ...

Hi,
for calculated values, right click the field - select field settings -
options - select "difference from" and select the base items
To add data, it is best to use "Dynamic ranges"
You can find info on both solutions at 'Excel -- Pivot Tables -- Custom
Calculations' (http://www.contextures.com/xlPivot10.html)
and 'Excel -- Names -- Naming Ranges'
(http://www.contextures.com/xlNames01.html#Dynamic)


Michel Groff;284280 Wrote:
Hi,
I have a PT with data in a text file.
I've learned that you can do wonderful things with the Value display
options
in a PT but I'm wondering if I'm asking too much and if I need to
a) add in some calculated values
b) go back and add some stuff to the underlying data in the text file.


I have a .gif picture here that explains it all.

http://www.fransysco.net/frogs/frogs2.gif

TIA

M.G.


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=79400

Pivot Table problem,
 

Well I don't see how the stuff on the site addresses the issue.
Maybe I am too dumb ?

The first link is an intro to the subtilities of the value display options.
The seond one is about referencing a range using offset.
I don't how that solves my problem.
Could you spell it out for me ?
pls.
MG

Pivot Table problem,
 

Excel 2007 Pivot Table
Running % total.
http://www.mediafire.com/file/4hwcwaui2ea/03_26_09.xlsx

Pivot Table problem,
 

Excellent.
Thanks.
This does appear to be the solution.
I'm working on it and will let you know, maybe next week.

MG


"Herbert Seidenberg" a écrit dans le message de
news: ...
Excel 2007 Pivot Table
Running % total.
http://www.mediafire.com/file/4hwcwaui2ea/03_26_09.xlsx

Pivot Table problem,
 

Herbert,
I don't understant this syntax
=1/nbval([name])

Should I understand
1 divided by the number of items having this name ?
It's not working for me in Excel 2007.

Anyway, my data is not in an XL spreadsheet, its in a text file.
I think I will have to get the percent result (the dividend) in the text
file data before excel can doit's work.
Or, at least, the quotient and the divisor.

Please advise.











"Michel Groff" a écrit dans le message de
news: ...
Excellent.
Thanks.
This does appear to be the solution.
I'm working on it and will let you know, maybe next week.

MG


"Herbert Seidenberg" a écrit dans le message de
news: ...
Excel 2007 Pivot Table
Running % total.
http://www.mediafire.com/file/4hwcwaui2ea/03_26_09.xlsx