Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Where you have to show like this?.You mean on selection?
Celambarasan
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.
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
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
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 |