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
Grouping example
Migrateduser
Hi,
Iam using 3.7.1v n XML as datasource to create a report where, it has main tags as G_4(for Reps), G_1 (customers),G_2 (orders). I have used row mapping on G_2 n two groups Group1-group by reps n group2- by customers. This gives results for Reps which has values but not reps(has rep name but no customer values-empty tags). I want to display rep names even if it doesnt have values for G_1 n G_2.
My output should look something like:
Rep1(name)
Customer1(number,name)
order1(num,order,qty..)
order2..
Rep2
Rep3
customer2
order1
Can you please advise how to do this? I never used crosstabs before can we use crosstab for this..
Thanks in advance
Find more posts tagged with
Comments
There are no comments yet