Dynamic sorting on summary field by clicking on the column of cross tab

nppk

<p class='bbc_left'><p class='bbc_left'></p></p>I am using a crosstab for displaying the number of products ordered per customers, per product.<br />
<br />
My rows are showing the customers, columns the products and as summary i am displaying the quantity.<br />
On clicking the product1(header), I need to sort the table based on the quantity of product1.<br />
<br />
For eg :<br />
<br />
cust | prd1 | prd2| prd3<br />

---

<br />
cust1 | 2 | 0 | 1<br />
cust2 | 1 | 4 | 3<br />
cust3 | 3 | 2 | 1 <br />
cust4 | 1 | 2 | 4<br />
<br />
so on clicking prd1 the result should be :<br />
<br />
cust | prd1 | prd2| prd3<br />
<br />
cust2 1 4 3<br />
cust4 1 2 4<br />
cust1 2 0 1<br />
cust3 3 2 1 <br />
<br />
clicking again on prd1 should result in :<br />
<br />
cust | prd1 | prd2| prd3<br />
<br />
cust3 3 2 1 <br />
cust1 2 0 1<br />
cust2 1 4 3<br />
cust4 1 2 4<br />
<br />
clicking on prd2 should result in <br />
<br />
cust | prd1 | prd2| prd3<br />
<br />
cust1 2 0 1<br />
cust3 3 2 1 <br />
cust4 1 2 4<br />
cust2 1 4 3<br />
<br />
Could you please suggest how to implement this.<br />
Please find the attached sample report with the post.<br />
<br />
Thanks in advance for the help

kclark

nppk, I'm working on an example for you but I think how it could be done is by using hidden parameters, have the crosstab sorted by the value of the parameter, and having the header links as drill-throughs linking back to itself passing the value of the header back to the hidden parameter.