6 Replies Latest reply: Feb 24, 2012 12:07 PM by david raab RSS

    Group by within an Expression

      Ok, there has to be an easy way to do this....

       

      I have a data set containing person name, company name, and company revenue.  Since there are multiple people per company, the company revenue figures are repeated several times.  I need a report showing number of people, number of companies, and total revenue.  How do I set this up in a pivot table to avoid the double counting?

       

      Thanks.