Category Override

[etaneaudi]

Hi. 

Each of our two locations has an A500 convertible car.  So, we should have two unique A500s in the convertible Model Type category.  However, because of how our data is structured, the pivot table recognizes an A500 in each of the convertible and station wagon Model Types.  How could I force both A500 units to show up in the convertible Model Type category?

The "Our Product" column is a measure with this formula: Count ( Distinct Product Model - Serial #).

The following graphic demonstrates how the raw data table is laid out, the current and the desired result:

Thanks!

edit: So, I found out it's possible to create a dimension with such logic:

if( left('Product Model - Serial #, 4) = 'A500', Model Type = 'Convertible', Model Type)

But, I need to figure out the correct syntax.  Thanks.