2 Replies Latest reply: Jul 1, 2011 8:01 PM by John Witherspoon RSS

    Limit Pivot table to 10 Results per GEO

    Naomi James

      I have a pivot table that is displaying opportunities set to expire in the next ten days by GEO. I want to display the important information for these deals so that the reps can follow up on them easily from the dashboard.  Right now I have the opportunity ID, Partner ACcount Name, and Customer Name displayed, along with a sum of the value of this opportunity.  I need to limit the data to 10 Opportunities per GEO (AMER, EMEA, APAC).  I have tried everything and can't figure out how to do this.  Can anyone help?  Also, not sure if you will need it, but this is the formula for the Pipeline Value:

       

       

      Screenshot.jpg

      Sum ( if (Approved=1 and [Expiration Date]-Today()<=10,[Registered Value SRP]))

      Approved means that the deal is still open to be closed.