I am using a matrix to display some numbers and in my data column, I am displaying average values. More specifically (# of actions/# of opportunties). This gives average # of actions performed per opportunity. And it's being displayed
per sales person. The columns are grouped by certain type of actions (phone call, email, voicemail). What I want to capture in the subtotal area is sum of the average, not the total average.
In otherwords, if 3.5 phone calls, 2 emails, and 2.5 voicemails, I want to display 8. Not 2.6. How is that done? Thanks.
View Complete Post