• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

Get your filters to stick in PivotTable reports

By admin on October 26, 2016April 19, 2019

Have you ever tried to make use of filters in your PivotTable reports, only to find that they don’t stick when you save your template back to the report in the Report Manager?  When your workbook is generated, maybe you’d prefer blank items to be hidden, or you would like it to default to the current year, for example.  This is all possible with an easy change to your PivotTable settings.
1.Run out your report and make the necessary changes to your PivotTable filters. This can include high level filters, field filters, label or value filters.

2. Once done, right click on your Table and select PivotTable Options.

3. Then, under the Data tab, set Number of items to retain per field to Automatic, and click OK.

4. Next, save your template back to your report in the Report Manager using the Save Excel Template button.

Now, the next time your run out your report, you’ll find that your filter settings have retained themselves. This saves you time and prevents you having to redo work when you run out your PivotTable reports.
The post Get your filters to stick in PivotTable reports appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

How to use a slicer instead of a drop-down list in Excel
How to easily double-check your Excel formula

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd