I'm trying to create a report that summarizes different columns with the same values for example i have 3 columns we will call A, B and C and each column has the same possible values of Yes, No and Maybe. So i would like a report to look like the example below. Can I do this on one report or do i have create 3 separate summary reports?
A
Yes # of Yes
No # of No
Maybe # of Maybes
B
Yes # of Yes
No # of No
Maybe # of Maybes
C
Yes # of Yes
No # of No
Maybe # of Maybes
3 réponses
You can get the data, but you'll need 3 reports. You can create 9 custom formula number fields on your record in this pattern:
IF(A = 'Y', 1, 0)
IF(A = 'N', 1, 0)
IF(A = 'M', 1, 0)
and repeat for B and C
Then, add a custom formula number field with the value 1
In your report, summarize by the 10th field (the constant 1).
Last, create 3 Report Formula fields to SUM three of the 9 formula fields.
Since a Summary report can only 'Total' 5 fields, the most sensible would be to make 3 copies of this report 1 for A, 1 for B, 1 for C.
