Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Dynamic sorting on summary field by clicking on the column of cross tab
Migrateduser
<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
Find more posts tagged with
Comments
There are no comments yet