First: You definitely want to go with a dashboard not a report.
Second: You should ask yourself the question if it absolutely makes sense to visualize the data using Splunk the exactly same way as you would to that in Excel. In most cases, people tend to and try to rebuild an existing Excel spreadsheet in the same way in Splunk. How ever, it often times makes complete sense so tweak and improve the visual representation and ease the implementation.
Have a look at good Splunk Dashboards and understand how they work. What drilldowns are used for, how you could place different panels showing different depths of detail.
Maybe you want to take the course "advanced dashboards and visualizations" or ask your Splunk SE to show you some options you have for the dashboard and ask him for help.
... View more