Let's say I have 3 tables as below:
each product in Products tab has the "catID"
In Categories tab I have categories with given catID, catName and parentCategoryID.
I have created a parent-child hierarchy using pattern which can be found here:
And everything works perfect, but the problem is that I have only sales by Categories. What I'd like to achieve is to have the possibility to drill down to check the sales of particular products in given category. Unfortunately it doesn't work properly.
You can check an example xls file enclosed
I would really appreciate any help.
Thanks in advance
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests