--- title: How to Change your pivot layout to 'Tabular Form' description: Instructions on how to change the view of your pivots so that they are represented in multiple columns and rows. --- [Skip to content](https://fundamentals.theretailscore.com/knowledge/how-to-change-your-pivot-layout-to-tabular-form#main-content) English Show submenu for translations [Customer portal](https://fundamentals.theretailscore.com/support-client-view?hsLang=en) ![mousemat.png\]](https://fundamentals.theretailscore.com/hs-fs/hubfs/mousemat.png?height=40&name=mousemat.png) Open main navigation Close main navigation - English Show submenu for translations - [Customer portal](https://fundamentals.theretailscore.com/support-client-view) - Go to theretailscore.com Go to theretailscore.com The Retail Score Fundamentals - There are no suggestions because the search field is empty. 1. [TRS Fundamentals](https://fundamentals.theretailscore.com/knowledge?hsLang=en) 2. [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en) 3. [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#03-get-help) # How to Change your pivot layout to 'Tabular Form' ## Instructions on how to change the view of your pivots so that they are represented in multiple columns and rows. When opening a PivotTable, the common excel default view is 'Compact Form'. See below image for example: ### Excel Pivot common default view - Compact Form PivotTables will usually default to opening in the Compact Form. Whilst this view allows the user to expand and collapse the attributes, it is not the ideal view when used for pivots with multiple values and attributes. ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Oct-27-2021-11-39-38-04-PM.png?width=204&name=image-png-Oct-27-2021-11-39-38-04-PM.png) ### To change an existing pivot to view in 'Tabular Form' Click in the pivot and from the top ribbon, select **Design | Report Layout | Show in Tabular Form** ![](https://fundamentals.theretailscore.com/hubfs/image-png-Oct-27-2021-11-43-48-48-PM.png) The view will now be in the below format - across multiple columns: ![](https://fundamentals.theretailscore.com/hs-fs/hubfs/image-png-Oct-27-2021-11-46-31-47-PM.png?width=357&name=image-png-Oct-27-2021-11-46-31-47-PM.png) ### Default all excel pivots to open to a 'Tabular Form' layout Follow the below instructions to change the view so that all excel pivots open directly in the Tabular Form view: Click: **File | Options | Data | Edit Default Layout**  - Change report layout to 'show in Tabular Form' - Change the Subtotals to 'do not show subtotals' (this can always be added back in at the level you wish to see it, but as a default, the recommended option is to not show them). ![](https://fundamentals.theretailscore.com/hubfs/image-png-Oct-27-2021-11-52-20-53-PM.png) ![](https://fundamentals.theretailscore.com/hubfs/image-png-Oct-27-2021-11-55-02-10-PM.png) ![](https://fundamentals.theretailscore.com/hubfs/image-png-Oct-27-2021-11-57-34-50-PM.png) - [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#01-getting-started) - [02 How to Guide](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-set-up?hsLang=en#03-get-help) - [tRS Insights Portal](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#01-getting-started) - [02 How To Guides](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal?hsLang=en#02-how-to-guides) - [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#main-content) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users?hsLang=en#03-get-help) - [tRS Modules](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#main-content) - [01 General Ledger](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#01-general-ledger) - [02 Traffic Counters](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#02-traffic-counters) - [04 Google Analytics](https://fundamentals.theretailscore.com/knowledge/trs-modules?hsLang=en#04-google-analytics) - [tRS Admin](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#01-getting-started) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-admin?hsLang=en#03-get-help) - [tRS Case Studies](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#main-content) - [01 Analysis](https://fundamentals.theretailscore.com/knowledge/trs-case-studies?hsLang=en#01-analysis) - [tRS Archive Library](https://fundamentals.theretailscore.com/knowledge/trs-archive-library?hsLang=en) - [tRS Development Release Notes](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#main-content) - [Releases](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes?hsLang=en#releases) - [tRS Connect](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#main-content) - [01 About](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#01-about) - [02 Set Up](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#02-set-up) - [03 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-connect?hsLang=en#03-getting-started) - [tRS Planner](https://fundamentals.theretailscore.com/knowledge/trs-planner?hsLang=en) [![Chill listening crop-3](https://fundamentals.theretailscore.com/hs-fs/hubfs/tRS1-2.png?width=102&height=55&name=tRS1-2.png "Chill listening crop-3")](http://theretailscore.com?hsLang=en) theretailscore.com Help Center Copyright © 2026, the Retail Score