![mousemat.png]](https://fundamentals.theretailscore.com/hs-fs/hubfs/mousemat.png?height=40&name=mousemat.png){kind=small}
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?
- How to Update a Workbooks ODC
- What does the Member module field "Is contactable" relate to?
- How can I see my transfer units once they have been received?
- How is Like for Like calculated in tRS?
- How to connect Power BI Desktop to the tRS cube
- Linking Returns to the Original Transaction Detail
- How to view Returns against the Original sale location
- Tip - Create a Shortcut to open your cube connection in excel
- Tips - How to convert your existing report to use Relative Periods
- Tips - How to Date Stamp your Report
- Tips - Set Report to Refresh on Opening
- What is the Shipment Method
- What is the difference between Location and Originating Location
- What is the difference between Demand Sales and Fulfilled Sales
- What is the difference between Retail Calendar, Financial Calendar and Calendar?
03 Get Help
- Why has my Pivot Fields Window Changed?
- Link to .xlsx Definitions file
- Why are some attribute fields blank in my pivot?
- Definitions of Sales measures
- How to improve the performance of pivots
- Reporting on Full Price and Markdown Sales and Stock
- How do I connect to the TRS cube using an Apple MAC
- What is the difference between Returns and Net Returns
- How to see Returns against the Original Sales Transaction
- Why doesn't my Sales number match my ERP
- How can I see my Purchase Order Receipts against the Receipt date? (AP21)
- What is the difference between Current Stock and Stock Tables in the cube?
- Why are some Sales Orders missing from my pivot (AP21)?
- How to Change your pivot layout to 'Tabular Form'
- Tips - Efficiencies when creating PivotTables
- Tips - Careful when making a PivotTable fields search
- Definitions of Sales Order and Invoices table measures - AP21
- Definitions of Production Order table measures - AP21
- Definitions of Purchase Order table measures - AP21
- Why does my GL stock value at cost differ from the Historical CSOH value at cost
- Definitions of Member table measures
- Glossary of common terms and acronyms
- Definitions of Stock measures
- Definitions of Current Stock measures
- How do I organise Pivot4Planners cube training?