BRM / RSM offers fantastic access to your raw data, and also to some structured reports and graphs.
But what do you do with that data?
imagine you want to analyse how your rental inventory has performed using pivot tables.
First of all extract all your bike data: Exporting data from BRM
Then when you have it in a google spreadsheet, create a pivot table.
Then add;
- Category (Cat) as your row
- Revenue (The first one, for current year) as your value (make sure you sum)
here is what it might look like:
Here is how the 'pivot table editor' might look within Google Spreadsheets, for example:
See also
a helpful video on using Pivot Tables in Google - non BRM resource, but very good background.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article