Pivot Table functionality

I'm new to Monarch and I'm still trying to get my bearings. I've been able to use the tool and create reports and I used Monarch's transform-Pivot feature to create a basic Pivot table Summary for my reports.

It does not seem as thought I was able to build the report to have the same functionality as an excel pivot table would have. With an excel pivot table, I'm able to double click on one of the summed numbers and it will open up a new tab composed of all the rows that make up that summed number.

Does Monarch have this functionality? If so, how do I create such a pivot table?