August 4, 2010 at 8:45 am
I have a dataset returned as below:
Province City ItemID Sales
BC Vancouver 1111 $100
BC Victoria 1111 $100
BC Vancouver 2222 $100
ON Toronto 1111 $200
ON Ottawa 1111 $100
ON Toronto 2222 $200
ON Ottawa 2222 $300
Bunisee requires the report to show sales for each item grouping by province and then drill down to city level of each itme. So the defalut page should like this:
Province ItemID Sales
BC 1111 $200
2222 $100
ON 1111 $300
2222 $500
When clicking the province + sign, report drills down to city level like this:
Province ItemID Sales
BC
Vancouver 1111 $100
2222 $100
Victoria 1111 $100
ON
Toronto 1111 $200
2222 $200
Ottawa 1111 $100
2222 $300
I spent a day on it, could not figure it out. I tried the grouping by two columns(province and itemid) in report group expression, however the output of the report repeatted for each province/itemed combination which is not what I need. Any help is appriecated.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply