Single Row of Data on Summary Report



I am setting up a Summary Report based on a few different sheets that all have Summary fields. I want to then have this information display in a single row on a Dashboard but I cannot figure out how to get all the information to appear on a single row.

My primary column lists the Sheet Names which I'm confident is what is causing the issue, but I cannot think of a different item to house in the Primary Column that would allow the data to display cleanly in a single row. If there are any suggestions that don't involve creating a new sheet to create the report, I would appreciate it.

Best Answer