Skip to Main Content
Status Unlikely to implement
Categories Reports
Created by Bryan Crist
Created on Jul 12, 2017

Invert columns and rows on list report

When creating a list report on our competitors, the competitors are placed on the vertical axis and the competitor fields are listed across the horizontal axis. I would love to be able to switch this, with the competitors across the top and fields down the side. This would allow for smaller row heights and make it easier to compare data across companies.

For example, if I have a long list of products for a competitor, I'm stuck doing a lot of scrolling to compare pricing among competitors because the row becomes so tall. If these were swapped, the Products row could be as tall as it wants since I'd be looking straight across the Pricing row to compare prices.

To get around this limitation, I have to export my report to Excel, transpose the table, and adjust all the column widths, which means I lose all of my formatting.

  • ADMIN RESPONSE
    Jul 22, 2022

    Thank you for your idea. One option here would be to create a pivot table. This would allow you to organize your competitors as columns with each of the relevant fields as rows.

    Given the flexibility to organize data in pivot tables we are unlikely to update list reports to allow similar customization.

  • Attach files