Subtract two variables inside a set analysis

[#1]

Hi all,

I'm trying to filter the content of a pivot table using a set analysis on a dimension, filtered by another dimension calculated on values obtained by the subtraction of two variables.

Example:

only({$<CustomeID={$(var_customed_id_selected)}-{$(var_customer_id_excluded)}>} Exhibition_edition)

Inside my pivot table I'd like to view customer's exhibition participation, but only for those customers selected minus customer excluded.

The set of customers excluded is obtained through another customer table not linked in the data model.

The pivot table is not filtered..

Any tips?

Thanks a lot,

Alessandro.

[#2]

The problem is not to show or not the 0 values.

The result of the set analysis is correct: the problem is that with a great amount of data (in order of 6 hundreds thousand of CustomerID), the calculation goes in time out and the application freezes.