Category Units Metric Can't Be Made

[Ecommerce_Analy]

I cannot figure out what I am doing incorrectly. I can apply the Units Metric to a Category value and get the correct result but when I try to build a calculated metric using Units and a segment for a category the results don't match.

Example I have 2 categories for products; Flights and Ancillaries. When I use the units metric against those I get the correct results Flights 1768 and Ancillaries 581. However when I try to create a calculated metric for just Flights Units (Category=Flights segment) I get the total; 2349. I think it has something to do with the fact those categories are always purchased together even though I am sending in separate products variables with the purchase event.

Seems like this should be a simple metric to create but I cant seem to find the magic formula

[fsakjlfdsakljfd · Accepted solution]

As of today Adobe does not allow 'sub-hit' segmentation.

Although sub-hit filtering can be done via dimension on a column in the freeform table - it doesn't behave that way within a segment.

What is your use case?  If its to trend over time it might be accomplished by dragging the specific product dimension on top of the units metric on the column in a table.