Calculation based on the result of Pivot Table in Access

C

Carson

Hi there,

I have generated a pivot table inside Access, but I want to do some
calculation based on the RESULT of the columns generated by Access. For
example, Indicator (Count)
Green Yellow Total
Process 1 12 10 22
Process 2 5 4 9
... .. .. ..

I'd like to add one column to the right: Score with a formula of, say,
IIF([Indicator]="Green",1,3)* (Count of Indicator).

Is it possible? Or I can only do it in Excel via an external link?

Hope you understand what I am asking.. :) THANKS!

Regards,
Carson
 
Top