Using column total in calculations
Content
I'm sure there is an easy solution for this, but I feel like I am tilting at windmills now. I have a cross tab report that breaks down chats by hour intervals, grouped by day of the week. I added a computed field for Report Percentage of Total, but to make it super easy to read and analyze by others, I would like to change that to percentage of daily chats (# of chats that hour / total chats for the day). Is there some way to use the daily total in a calculation? I could then write count (chats.requested) / [daily
Tagged:
1