Skip to Content
0
Former Member
Jun 14, 2007 at 07:23 PM

Cross Tab And summary fields

7 Views

<p>Hello Guys, </p><p>Need your help for the following problem:</p><p>1. In a Crosstab i have the customers in the Rows and the sum(invoiceamount) in the summarised fields. I have sort (group sort expert) to show the top 10 customers. Now i want to show what is the <strong>sum(of the invoice amount of the top 10 customers only), sum(of the invoice amount of the other customers), sum(invoice amount for all the customers). <font color="#ff6600">How do i get this</font></strong></p><p>2. I have year on Year comparison report. Customer in rows, order date(summarised for each year) in columns, sum(invoiceamount) in the summarised fields. <strong>Now i want to show what was the % growth or decline from last year.</strong> <strong><font color="#ff6600">How do i get this</font></strong></p><p>If you need any more information or explanation please let me know....</p><p>Any help is welcomed</p><p>Vignesh</p>