summary to detailed report drilling in 10g
901695Feb 15 2012 — edited Feb 21 2012Hi All,
Actually i want to ask you two questions...
1. how to create a summary report where the columns need to be product category, salestatus and value.
Here, salestatus has two common values for all categories i.e <5m and >=5m
value column is the count of no of products belong to the particular salestatus..
ex:
category----salestatus----value
AAAA-------- <5M-----------5
--------------->=5M----------2
BBB-----------<5M-----------10
--------------->=5M----------3
the source cols i have are prodcat,prodname and amount sold...
2. when we click the value col.. it will navigate to a detailed report that must be filtered to show the matching values..
suppose if i click '5' in the above example.. then the detailed rport has to be filtered to show
AAAA products whose sales is less than 5M..
pls advise me...
thanks!
Edited by: 898692 on Feb 15, 2012 1:38 AM
Edited by: 898692 on Feb 15, 2012 1:39 AM