C
Chuck W
Hi,
I have a report based on a cross tab query. The query has Product and
Answer as Row headings and Month as a Column heading. The value is the
counts of a numeric value. I have four products and two answers (Yes or No).
I then summed the Yes or Nos so I have the totals by product. My data looks
like this:
Product Answer January February March
Prod A
No 1 2
Yes 8 5 10
Sum 9 5 12
Prod B
No 2 1
Yes 8 5
Sum 10 1 5
What I want to do is the create another calculated field below sum for each
product which give a percentage of Yes values. For product A it would be
..88% (8/9) for Jan, 100% (null value/5) for Feb and 83% (10/12) for March.
Is it possible to do this?
Thanks,
I have a report based on a cross tab query. The query has Product and
Answer as Row headings and Month as a Column heading. The value is the
counts of a numeric value. I have four products and two answers (Yes or No).
I then summed the Yes or Nos so I have the totals by product. My data looks
like this:
Product Answer January February March
Prod A
No 1 2
Yes 8 5 10
Sum 9 5 12
Prod B
No 2 1
Yes 8 5
Sum 10 1 5
What I want to do is the create another calculated field below sum for each
product which give a percentage of Yes values. For product A it would be
..88% (8/9) for Jan, 100% (null value/5) for Feb and 83% (10/12) for March.
Is it possible to do this?
Thanks,