[Eric DeVito]

It sounds as if your Worksheet is consolidating and not considering your alias values. You should review your consolidation criteria as described in this Knowledge Base Article