Combined?

[n1ef5ng1]

Attached file as below,

In the qlikview file, there is two table call desire table and Total Box.

I having problem putting a value on Total Box Dwell Days in Desire Table

I am able to achieve the value if I can create a table call Total Box,

The value for Over Type,Month 10, will be (3*2) + (6*4) = 30,

Value fo Important Type, Month 10, will be (4*1) + (8*5) = 44

Thus, the value of 30 and 44 should be in Desire table,

Thanks very much!

I believe is aggr but I have no clue on how to do it

[swuehl]

This is a duplicate post, isn't it? Try avoiding this, it makes it hard to follow a discussion.

=sum(aggr(Days*sum(Box), Month,Type,Days))