Hey,
Sorry this might not be advanced, but it is to me
I'm using pivot tables to analyze alot of data.
I wanted to perform calculations on some of the fields, and
contain this information in the report of the table.
Eg like get the percentage of a few columns?
If no one knows this, i was wondering is using VLOOKUP is the way to go?
and have the values say of the months figures being copied into a set report on another page. The problem with this was that if the pivot table changes then doesn't the whole VLOOKUP totally stuff up?
I'm looking into the new Cube Analysis upgrade for excel 2003, I'm not sure if that will solve all my problems but we will see
thanks
vivek.
Sorry this might not be advanced, but it is to me
I'm using pivot tables to analyze alot of data.
I wanted to perform calculations on some of the fields, and
contain this information in the report of the table.
Eg like get the percentage of a few columns?
If no one knows this, i was wondering is using VLOOKUP is the way to go?
and have the values say of the months figures being copied into a set report on another page. The problem with this was that if the pivot table changes then doesn't the whole VLOOKUP totally stuff up?
I'm looking into the new Cube Analysis upgrade for excel 2003, I'm not sure if that will solve all my problems but we will see
thanks
vivek.