I’m trying to record win/loss of an online game, here is what I got:
http://share.creoweb.it/3a93ff8e.jpg
The table quite doest looks like to what I expected, the % is wrong and there are no totals. My ideal result is having hero name on rows, and columns with days of the week, a subset for every day is the hour, and for every hour I want to see the win rate relative to that hero/day/hour and total games played like:
Monday Hero 10 | 15 | 20 Gauss 50% | 18 | .......
and so on for every hero/day/hour. I’m not sure if this is doable using pivot tables or if I should manually filter the data creating a custom report. I don’t need the extra functionalities of the pivot, like moving columns/rows or apply filters etc… just a static view so that I can monitor my performances. I’ll have to do similr talbes for other metric but this is the overall idea.