Need Product Category Dashboard Help

[jaspsing]

Hello There,

help me creating dashboard for nth level of category for product.

I have 3 tables.

1 product table: categoryid,productid, productname.

2. categorytable: categoryid, categoryname,parentid

3. Sale: productid, qty, amount,date

Now I need to show like this:

Electronics--> Computers--> Pendrive

Sale Data

How to to that.

[CELAMBARASAN]

Hi,

     Where you have to show like this?.You mean on selection?

Celambarasan

[jaspsing]

Thanks for your attention and reply.

I need to show List Box of First level Category,  You can take example of one shopping site ebay , flipkart any. I want to show the top category to lower category drill down sales graph.

Now hope you can have correct idea.

[Anonymous]

Hi

     I have attached one qv file based on your first request.

     See this attached file and let me know your clear requirement

Regards

Ashok

[CELAMBARASAN]

Hi,

     Create a drill down group for this fileds.then create a list box with that drilldown group as expression.

     =DrillDownGroup

Hope it helps

Celambarasan

[jaspsing]

CategoryId	CategoryName	ParentId
1	Electronics
2	Accessories
3	Food
4	Home & Kitchen
5	Fans	13
6	Computers	1
7	Pen Drives	6
8	Mobiles	1
9	Camera	1
10	Clothes	2
11	Jeans	10
12	T-shirts	10
13	Home Appliances	4
14	Kitchen Appliances	4
15	Namkeens	3
16	Biscuits	3

How to Create Drill Down of Category Name till product Name

CategoryId	ProductId	ProductName
7	1	Kingston 2 Gb
8	2	Nokia Lumia
9	3	Canon 100
15	4	Namkeen Mixture
16	5	Butter Bite
5	6	Bajaj ceiling fan-100