I found my behavior that is causing this to be a calculated member
I have create the following tendency
My issue is that in excel if I use this (or the kpi) the heritages aren't take in account and each heiritable show all possible results instead of
ignore those that is suppose to be filter by.
It should show
America USA 1 1 0 OK Colombia 1 0 1 OK Brazil 0 0 0 Bad Asia Japan 1 1 1 OK
But instead it shows
America USA 1 1 0 OK Colombia 1 0 1 OK Brazil 0 0 0 Bad Japan OK Asia USA OK Colombia OK Brazil Bad Japan 1 1 1 OK
Can anyone point me what I am doing wrong?