Skip to Content
0
Former Member
Sep 20, 2010 at 11:04 PM

How to display both total and subtotal with condition on

39 Views

Hi Experts,

We had a special requirements from our "Powerful" user for a top sales ranking report:

say user runs for top 10 customers, query/view (It has to be built as query/views because they are going be exported to Portal) need to show

1. sub total 10 customers

2. total for all customers

3. for each customer to show their sales percentage out of the overall total sales

any recommendation welcomes

Regards,

Feng