I’m to lazy to add reservations manually to Google Trips. I tried to fake hotel confirmation emails and it really works pretty good with just these information :
Title : Your hotel reservation
Detailed hotel address including phone number and web address.
check in : (check in date)
check out : (check out date)
Thank you very much for your reservation we are looking forward to welcome you.
This Spreadsheet will contain all my examples, the first one is a Pivot based on Region and Turnover with the Areas of Business which require attention (where we actually lose money) marked red using conditional formatting.
Current Example in Spreadsheet: “Region / Category”.
The advantage of manual pivots from my point of view is the fact the query could be adjusted and it stays dynamic as when we use UI pivots and change the filter new values are filtered out automatically.