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
sorting on summary field by clicking on the column of cross tab
Migrateduser
I am using a crosstab for displaying the number of products ordered per customers, per product.
My rows are showing the customers, columns the products and as summary i am displaying the quantity.
On clicking the product1(header), I need to sort the table based on the quantity of product1.
For eg :
cust | prd1 | prd2| prd3
cust1 | 2 | 0 | 1
cust2 | 1 | 4 | 3
cust3 | 3 | 2 | 1
cust4 | 1 | 2 | 4
so on clicking prd1 the result should be :
cust | prd1 | prd2| prd3
cust2 1 4 3
cust4 1 2 4
cust1 2 0 1
cust3 3 2 1
clicking again on prd1 should result in :
cust | prd1 | prd2| prd3
cust3 3 2 1
cust1 2 0 1
cust2 1 4 3
cust4 1 2 4
clicking on prd2 should result in
cust | prd1 | prd2| prd3
cust1 2 0 1
cust3 3 2 1
cust4 1 2 4
cust2 1 4 3
Could you please suggest how to implement this.
Please find the attached sample report with the post.
Thanks in advance for the help
Find more posts tagged with
Comments
There are no comments yet