Sum in cross table from another table

[Mickal M.]

Hi dear Spotfire friends,

To illustrate my issue, here are 2 tables, one with sales, one with working days. Those table match by their Month and Employee columns.

 

Now I want to create a cross table like this which agregates by employee and item:

 

 

It works well if the cross table is not limited. But if I add the condition [month]='June', the "total working days" remains 35 and 22. I don't understand why. Any suggestion

Thanks a lot.

Mickael

[Mickal M.]

My bad, it's simple, I just need to add the condition in the calculation itself:

sum(if([working days].[Month]='june',[working days].[Working days],0))