I'm trying to create a report for a swimming club, with a pivot table: row dimension = date + swimmer name, column dimension = stroke, metric = swim time (using average as single record for these dimensions). I can get close to what I want, but can only show the duration down to hh:mm:ss. What I need to show (given it's swimming times) is mm:ss:milliseconds. Any suggestions how this can be achieved?
LinkedIn
Twitter
