Cynthia,
That is what i'm looking for but i can't figure out how to hide the "QtrGoal" and "calcpct" columns.
[pre]
Rep
100 200
FiscalQtr week_end Sales qtrGoal calcpct Sales QtrGoal calcpct
3 7/3/2010 $113,754.50 $3,551,296.25 3.20% $118,793.00 $4,503,190.00 2.64%
7/10/2010 $256,828.50 $3,551,296.25 7.23% $291,422.50 $4,503,190.00 6.47%
7/17/2010 $227,376.50 $3,551,296.25 6.40% $266,476.50 $4,503,190.00 5.92%
7/24/2010 $231,753.00 $3,551,296.25 6.53% $277,350.00 $4,503,190.00 6.16%
7/31/2010 $236,743.50 $3,551,296.25 6.67% $286,673.50 $4,503,190.00 6.37%
8/7/2010 $265,156.50 $3,551,296.25 7.47% $309,149.50 $4,503,190.00 6.87%
8/14/2010 $222,688.00 $3,551,296.25 6.27% $289,689.00 $4,503,190.00 6.43%
3 $1,554,300.50 $3,551,296.25 43.77% $1,839,554.00 $4,503,190.00 40.85%
[/pre]
After hiding the qtrgoal and calcpct report should look like:
[pre]
Rep
100 200
FiscalQtr week_end Sales Sales
3 7/3/2010 $113,754.50 $118,793.00
7/10/2010 $256,828.50 $291,422.50
7/17/2010 $227,376.50 $266,476.50
7/24/2010 $231,753.00 $277,350.00
7/31/2010 $236,743.50 $286,673.50
8/7/2010 $265,156.50 $309,149.50
8/14/2010 $222,688.00 $289,689.00
3 Total Sales $1,554,300.50 $1,839,554.00
Qtr Goal $3,551,296.25 $4,503,190.00
Calcpct 43.77% 40.85%
[/pre]
... View more