Strange pivot table behavior

[Anonymous]

Greetings to the community!

I struggle with the following Pivot table behavior:

Screenshot 101: Order Month-Project-Product, the TOTAL<Month> gives me the right values;

Screenshot 102: Order Product-Month-Project, the TOTAL<Month> gives the right values when all the levels are open,

however

Screenshot 103: same order, but when I close one of the drills (part. 'Door'), I get wrong total values.

What is wrong here - either it's me and a lack of understanding of Qlik features or is it a bug?

I've attached the the app with this table.

[sunny_talwar]

What is the total you are expecting to see? I am trying to understand that bit

[Anonymous]

I want to get the 101 and 102 slide TOTAL <Month> disregarding the selections and drill-down states, like the ones I get in Screenshot 101 and 102, so basically it should show me the total costs per month in any of view combinations.

It would be the total cost of specific product per month.

[sunny_talwar]

May be this

If(Dimensionality() = 3, Aggr(nodistinct Sum(Cost), Month), Sum(TOTAL <Month> Cost))

[Anonymous]

Nice! It works when the Month is at the level 3, however, when I move the month to the second level, it breaks. Maybe You know the trick?

[sunny_talwar]

Month is at the second level here, what's wrong?

[alextimofeyev]

Sunny,

Look at the value for "January" on the second level under "Door". It's 305, but it's supposed to be 420, just like the levels below.

[sunny_talwar]

I see what you mean..... now.... I will take a look at this and