Yes, that's possible. If the pivot or chart features do not meet your report requirement, then we recommend using a tool like Google Looker Studio to build report on top of your backed up data.
Note: The primary goal of the sync to Google Drive is to make your backed data accessible. It is not designed to be used as a reporting tool.