Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below tables. I need to create a pivot showing the products sold by months for the selected Quarter and Category. If there is no data for a combination, it should still show the Product and the month with 0. My problem is, if I select show all values, it is displaying products for all categories. I need to show all the products and all months for only the selected Q and Category. Appreciate your help.
Quarter | Month |
---|---|
Quarter | Month |
Q1 | Jan |
Q1 | Feb |
Q1 | Mar |
Q2 | Apr |
Q2 | May |
Q2 | Jun |
Q3 | Jul |
Q3 | Aug |
Q3 | Sep |
Q4 | Oct |
Q4 | Nov |
Q4 | Dec |
Category | Product |
---|---|
Electronics | Accessories |
Electronics | Audio & Video |
Electronics | Cell Phone |
Electronics | Computer & Tablet |
Electronics | TV & Home Theater |
Home & Garden | Appliances |
Home & Garden | Bed & Bath |
Home & Garden | Furniture |
Home & Garden | Home Improvement & Tools |
Home & Garden | Kitchen & Dining |
Food | Coffee & Tea |
Food | Gift Cards |
Food | Restaurants |
Food | Wine & Sweet |
Thanks.
Can some one help me?
Regards
in order to get the report based on some calendar, we should have a join between the main table and calendar.
If not we can not drill down based on calendar quarter.
I have all the joins... my problem is the user wants to see all the Products for the selected Category and all months for the selected quarter even if there is no data for that combination. In the below table, there are no records for Cell Phones and the month March. Still it should appear on the report. If I check, "Show All Values", then it is displaying all products for all categories.
Product | Jan | Feb | Mar |
Accessories | 200 | ||
Audio & Video | 530 | ||
Cell Phones | |||
Computers & Tablets | 500 |
Thanks
I think you need to post your qvw or a representative sample. I think there may be a problem with your data model and/or your calendar.
Preparing examples for Upload - Reduction and Data Scrambling