This discussion is archived
5 Replies Latest reply: May 20, 2011 6:22 AM by 844580 RSS

Limit number of records in pivot table

844580 Newbie
Currently Being Moderated
Hello,

how can i show only 10 first recors in a custom report?

thanks.
  • 1. Re: Limit number of records in pivot table
    763243 Explorer
    Currently Being Moderated
    Hello Luis,

    You want to limit the no of records in a pivot table. Hence, I would like to know how you would identify the 10 records. If we have the logic to identify the 10 reacords, then we will be able to limit the number of records to 10.

    Regards,

    Paul
  • 2. Re: Limit number of records in pivot table
    796572 Newbie
    Currently Being Moderated
    If you want to display ONLY 10 records overall in the report, then you need some logic for identifying the 10 records as Paul said.

    However for a normal table view if you want to display only 10 records per page instead of the default 25, you can change it. On Step two, Go to the table's Edit View and click on Edit Table View Properties and modify the Rows per Page setting.

    Udaya
  • 3. Re: Limit number of records in pivot table
    844580 Newbie
    Currently Being Moderated
    Hello,

    I have some accounts, each accounts have many assets. i'll order the assets by the quantity. i want to show only the 10 first assets for each account.

    its possible?

    thanks.
  • 4. Re: Limit number of records in pivot table
    763243 Explorer
    Currently Being Moderated
    Hi Luis Simioni

    This is a very very simple report.
    Select the report from the Asset or Asset History
    Include the columns, Account Name, Asset, Quantity and once again Quantity.
    In the fourth Quantity column please apply the formula (in fx part) RANK("- Quantity".Quantity By Account."Account Name")
    After applying the formula, please select the filter less than 11.
    You can then hide the fourth column.


    The RANK function would give rank each asset based on the their quantity. We are applying the phrase By Account."Account Name" so that the ranking is done separately for each account name. We are then applying the filter less than 11, so that only 10 records are displayed in the report.

    Once the number of records are limited then you can apply the pivot accordingly and get the output.

    Let me know if you are still facing issues.
    You can mail me at spaul@crmit.com for any issues.

    Regards,

    Paul

    Edited by: Paul-CRMIT on May 19, 2011 11:17 AM
  • 5. Re: Limit number of records in pivot table
    844580 Newbie
    Currently Being Moderated
    Thanks Paul,

    it work's fine.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points