--- title: tRS Pivot4Power Users | TRS Fundamentals description: This category contains articles to help service and support customers using Pivots and accessing the cube. --- [Skip to content](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users#main-content) English Show submenu for translations [Customer portal](https://fundamentals.theretailscore.com/support-client-view) ![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) 2. [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users) # tRS Pivot4Power Users This category contains articles to help service and support customers using Pivots and accessing the cube. ## 02 How To Guide - [What Budget types are available?](https://fundamentals.theretailscore.com/knowledge/what-retail-budget-types-are-available) - [How to Update a Workbooks ODC](https://fundamentals.theretailscore.com/knowledge/how-to-update-a-workbooks-odc) - [What does the Member module field "Is contactable" relate to?](https://fundamentals.theretailscore.com/knowledge/what-does-the-member-module-field-is-contactable-relate-to) - [How can I see my transfer units once they have been received?](https://fundamentals.theretailscore.com/knowledge/how-can-i-see-my-transfer-units-once-they-have-been-received) - [How to connect Power BI Desktop to the tRS cube](https://fundamentals.theretailscore.com/knowledge/how-to-connect-to-powerbi-desktop) - [How is Like for Like calculated in tRS?](https://fundamentals.theretailscore.com/knowledge/how-does-like-for-like-lfl-work-in-trs) - [Linking Returns to the Original Transaction Detail](https://fundamentals.theretailscore.com/knowledge/linking-returns-to-the-original-transaction) - [How to view Returns against the Original sale location](https://fundamentals.theretailscore.com/knowledge/how-to-view-returns-where-the-sale-originated-online) - [Tip - Create a Shortcut to open your cube connection in excel](https://fundamentals.theretailscore.com/knowledge/shortcut-to-opening-your-cube) - [Tips - How to convert your existing report to use Relative Periods](https://fundamentals.theretailscore.com/knowledge/how-to-convert-your-existing-report-to-use-relative-period) - [Tips - How to Date Stamp your Report](https://fundamentals.theretailscore.com/knowledge/how-to-date-stamp-your-report) - [Tips - Set Report to Refresh on Opening](https://fundamentals.theretailscore.com/knowledge/set-report-to-refresh-on-opening) - [What is the Shipment Method](https://fundamentals.theretailscore.com/knowledge/what-is-the-shipment-method) - [What is the difference between Location and Originating Location](https://fundamentals.theretailscore.com/knowledge/what-is-the-difference-between-location-and-originating-location) - [What is the difference between Demand Sales and Fulfilled Sales](https://fundamentals.theretailscore.com/knowledge/what-is-the-difference-between-demand-sales-and-fulfilled-sales) - [What is the difference between Retail Calendar, Financial Calendar and Calendar?](https://fundamentals.theretailscore.com/knowledge/what-is-the-difference-between-calendar-retail-calendar-and-financial-calendar) See less ▼ ## 03 Get Help - [Link to .xlsx Definitions file](https://fundamentals.theretailscore.com/knowledge/link-to-definitions) - [Why has my Pivot Fields Window Changed?](https://fundamentals.theretailscore.com/knowledge/why-has-my-pivot-fields-window-changed) - [Why are some attribute fields blank in my pivot?](https://fundamentals.theretailscore.com/knowledge/why-are-some-fields-blank-in-my-pivot) - [Definitions of Sales measures](https://fundamentals.theretailscore.com/knowledge/definitions-of-sales-measures) - [How to improve the performance of pivots](https://fundamentals.theretailscore.com/knowledge/how-to-improve-the-performance-of-pivots) - [Reporting on Full Price and Markdown Sales and Stock](https://fundamentals.theretailscore.com/knowledge/sales-markdown) - [How do I connect to the TRS cube using an Apple MAC](https://fundamentals.theretailscore.com/knowledge/how-do-i-connect-to-the-trs-cube-using-a-mac-computer) - [What is the difference between Returns and Net Returns](https://fundamentals.theretailscore.com/knowledge/what-is-the-difference-between-returns-and-net-returns) - [How to see Returns against the Original Sales Transaction](https://fundamentals.theretailscore.com/knowledge/how-to-see-returns-against-the-original-sales-transaction) - [Why doesn't my Sales number match my ERP](https://fundamentals.theretailscore.com/knowledge/why-dont-my-sales-number-match-my-erp) - [How can I see my Purchase Order Receipts against the Receipt date? (AP21)](https://fundamentals.theretailscore.com/knowledge/how-can-i-see-my-po-receipts-against-the-receipt-date-ap21) - [What is the difference between Current Stock and Stock Tables in the cube?](https://fundamentals.theretailscore.com/knowledge/what-is-the-difference-between-current-stock-and-stock-tables-in-the-cube) - [Why are some Sales Orders missing from my pivot (AP21)?](https://fundamentals.theretailscore.com/knowledge/why-are-some-sales-orders-missing-from-my-pivot-ap21) - [How to Change your pivot layout to 'Tabular Form'](https://fundamentals.theretailscore.com/knowledge/how-to-change-your-pivot-layout-to-tabular-form) - [Tips - Efficiencies when creating PivotTables](https://fundamentals.theretailscore.com/knowledge/efficiencies-in-creating-detailed-reports) - [Tips - Careful when making a PivotTable fields search](https://fundamentals.theretailscore.com/knowledge/tips-) - [Definitions of Sales Order and Invoices table measures - AP21](https://fundamentals.theretailscore.com/knowledge/definitions-of-sales-order-and-invoices-table-measures-ap21) - [Definitions of Production Order table measures - AP21](https://fundamentals.theretailscore.com/knowledge/definitions-of-production-order-table-measures-ap21) - [Definitions of Purchase Order table measures - AP21](https://fundamentals.theretailscore.com/knowledge/definitions-of-purchase-order-table-measures) - [Why does my GL stock value at cost differ from the Historical CSOH value at cost](https://fundamentals.theretailscore.com/knowledge/why-does-my-gl-stock-value-at-cost-differ-from-the-historical-csoh-value-at-cost) - [Definitions of Member table measures](https://fundamentals.theretailscore.com/knowledge/definitions-of-member-table-measures) - [Glossary of common terms and acronyms](https://fundamentals.theretailscore.com/knowledge/common-dictionary-of-terms-and-acronyms) - [Definitions of Stock measures](https://fundamentals.theretailscore.com/knowledge/definitions-of-stock-measures) - [Definitions of Current Stock measures](https://fundamentals.theretailscore.com/knowledge/definition-of-current-stock-measures) - [How do I organise Pivot4Planners cube training?](https://fundamentals.theretailscore.com/knowledge/how-do-i-organise-training) See less ▼ - [tRS Set Up](https://fundamentals.theretailscore.com/knowledge/trs-set-up#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-set-up#01-getting-started) - [02 How to Guide](https://fundamentals.theretailscore.com/knowledge/trs-set-up#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-set-up#03-get-help) - [tRS Insights Portal](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal#01-getting-started) - [02 How To Guides](https://fundamentals.theretailscore.com/knowledge/trs-insights-portal#02-how-to-guides) - [tRS Pivot4Power Users](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users#main-content) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-pivot4power-users#03-get-help) - [tRS Modules](https://fundamentals.theretailscore.com/knowledge/trs-modules#main-content) - [01 General Ledger](https://fundamentals.theretailscore.com/knowledge/trs-modules#01-general-ledger) - [02 Traffic Counters](https://fundamentals.theretailscore.com/knowledge/trs-modules#02-traffic-counters) - [04 Google Analytics](https://fundamentals.theretailscore.com/knowledge/trs-modules#04-google-analytics) - [tRS Admin](https://fundamentals.theretailscore.com/knowledge/trs-admin#main-content) - [01 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-admin#01-getting-started) - [02 How To Guide](https://fundamentals.theretailscore.com/knowledge/trs-admin#02-how-to-guide) - [03 Get Help](https://fundamentals.theretailscore.com/knowledge/trs-admin#03-get-help) - [tRS Case Studies](https://fundamentals.theretailscore.com/knowledge/trs-case-studies#main-content) - [01 Analysis](https://fundamentals.theretailscore.com/knowledge/trs-case-studies#01-analysis) - [tRS Archive Library](https://fundamentals.theretailscore.com/knowledge/trs-archive-library) - [tRS Development Release Notes](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes#main-content) - [Releases](https://fundamentals.theretailscore.com/knowledge/trs-development-release-notes#releases) - [tRS Connect](https://fundamentals.theretailscore.com/knowledge/trs-connect#main-content) - [01 About](https://fundamentals.theretailscore.com/knowledge/trs-connect#01-about) - [02 Set Up](https://fundamentals.theretailscore.com/knowledge/trs-connect#02-set-up) - [03 Getting Started](https://fundamentals.theretailscore.com/knowledge/trs-connect#03-getting-started) - [tRS Planner](https://fundamentals.theretailscore.com/knowledge/trs-planner) [![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) theretailscore.com Help Center Copyright © 2026, the Retail Score