Skip to Content
0
Former Member
Jul 17, 2007 at 02:45 PM

Detail Top 80% and line other for 20%

10 Views

Hello Gurus,

I have a query where I want to show the top 80% based on a certain amount. I would like to see also a line with the difference "others" between the total amount and the total top x (instead of being obliged to calculate it myself)

Customer 1 200 10%

Customer 2 100 15%

Customer 3 80 15%

Customer 4 50 42%

Others 70 18%

Total Overdue amount: 500

If I use the TOP % Condition I have the detail and total but I can't obtain the difference line.

Thanks for the help.