I have a number of projects and each one can be tested a number or times. Each test will give a score, X passed out of Y criteria. So my columns in base data are project, date of test, maximum score, actual score. Example rows might be
project1,20050115,23,18
project1,20050206,14,5
project2,20050301,22,21
I want to generate a pivot table that shows how the score (as a %age) is shaping up for each project as months go by. I have managed to get running total scores month by month, e.g. for project1 using above sample data:
Jan,23,18
Feb,37,23
Mar,37,23
What I can't figure out is how to express the score as a %age in the pivot table i.e. I would like to have
Jan,23,18,78%
Feb,37,23,62%
Mar,37,23,62%
...but when I add a %age calculated field I get
Jan,23,18,78%
Feb,37,23,36%
Mar,37,23,#N/A
i.e. it's calculating a %age for the scores that fall within the month, not based on the cumulative score.
project1,20050115,23,18
project1,20050206,14,5
project2,20050301,22,21
I want to generate a pivot table that shows how the score (as a %age) is shaping up for each project as months go by. I have managed to get running total scores month by month, e.g. for project1 using above sample data:
Jan,23,18
Feb,37,23
Mar,37,23
What I can't figure out is how to express the score as a %age in the pivot table i.e. I would like to have
Jan,23,18,78%
Feb,37,23,62%
Mar,37,23,62%
...but when I add a %age calculated field I get
Jan,23,18,78%
Feb,37,23,36%
Mar,37,23,#N/A
i.e. it's calculating a %age for the scores that fall within the month, not based on the cumulative score.
