cstlaurent
Board Regular
- Joined
- Jan 14, 2005
- Messages
- 182
I am still looking first of all if it's possible, with the getpivotdata to retreive a sum from the pivot data of an array of cell. Ex:
I want the sum of all the center that is included in an array.
sum of $center .. date
center ...............01-01-05 02-01-05 03-01-05 04-01-05 05-01-05
2001..................100 150 200 300 100
2002..................200 400 150 100 400
2003..................50 75 200 150 170
2004..................80 10 200 100 85
2005..................150 100 80 90 200
2006..................100 150 80 200 400
2007..................90 90 90 90 90
array of selection
2001
2002
2005
2006
I allready use the function sumproduct instead of the crosstable, but it was taking way to much time, because I have a few thousand of record to go look into each time.
Any help will be appréciate.
thanks
I want the sum of all the center that is included in an array.
sum of $center .. date
center ...............01-01-05 02-01-05 03-01-05 04-01-05 05-01-05
2001..................100 150 200 300 100
2002..................200 400 150 100 400
2003..................50 75 200 150 170
2004..................80 10 200 100 85
2005..................150 100 80 90 200
2006..................100 150 80 200 400
2007..................90 90 90 90 90
array of selection
2001
2002
2005
2006
I allready use the function sumproduct instead of the crosstable, but it was taking way to much time, because I have a few thousand of record to go look into each time.
Any help will be appréciate.
thanks