Pivot Table problem,

[Michel Groff]

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]

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 -- Custo
Calculations' (http://www.contextures.com/xlPivot10.html)
and 'Excel -- Names -- Naming Ranges
(http://www.contextures.com/xlNames01.html#Dynamic)

Hi,
I have a PT with data in a text file.
I've learned that you can do wonderful things with the Value displa
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

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste

 

[Michel Groff]

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

 

[Michel Groff]

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

 

[Herbert Seidenberg]

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

 

[Michel Groff]

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

MG

 

[Par_exemple_Rosalie_Mignon]

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.