Preventing totals for text expresions on Pivot tables

[#1]

have a pivot table which has products with their planned source and destination with the associated costs....

I have a 2nd table which has other ' sourcing options' with their associated costs. I calculate the sources that would be the least expensive ( Source 1, Source 2, Source 3) using an expression but the end result is a name of a location (i.e florida, colorado, california, etc) but in my pivot table when everything is aggregated up to the product level, it shows the "Total" for the  Source 1 as Florida, which really makes no sense.

I want it to show the  Source 1, 2, 3 only when I've expanded from Product to Destination.

Any idea on how to go about this?

[#2]

Thanks Jordi. I found a way to make this work for now. It's the following:

If([Dimensionality()>4, If([Destination Location="Option1", 'Y','N'), )

Means if dimensionality is greater than 4, calculate this (If([Destination Location="Option1", 'Y','N')) , otherwise leave it blank.