Pivot Table problem,

  • Thread starter Thread starter Michel Groff
  • Start date Start date
M

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.
 
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
 
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
 
Excellent.
Thanks.
This does appear to be the solution.
I'm working on it and will let you know, maybe next week.

MG
 
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.
 
Back
Top