In Excel 2003, I have a product hierarchy, for simplistic sake lets say it goes A > B > C > model nbr. I have filtered on model nbr 1. I have the product hierarchy in my pivot table and unit cnt as the measure.
Starting at level A in the hierarchy I am showing a total unit of 12000, if I drill down to B it still shows 12000, if I drill down to C it shows 100 and if I drill down to model nbr it shows me model nbr 1 with a unit cnt of 100.
So my question is why are my parents not filtering the model nbr, it is taking the total for ALL records that have level A as their parent regardless of the model nbr?
This does NOT happen in Excel 2007 or when I browse my cube in SSAS.
View Complete Post