In my pivot table I want to show the sales for Brands. But I only want to show it in Cities with a total sales above a certain amount. After some tries I managed to get this situation in my pivot table (see table "Sales if total" in the attached file). Unfortunatly the subtotals are wrong in this table. The subtotals are calculated including the values of the excluded items. Can someone please help me with the solution to this problem?
As I'm new to Qlikview, i'm taking things step by step, trying to understand what is happening. As you probably saw there is another variable for date. If I try putting the variable date in your expression, the pivot table has the same problem as before. The pivot table shows the correct data, but the subtotals are wrong.