Hi,

I need to specify two conditions from the same hierarchy and am running
into problems. As an example, how could I create a query (from the
Foodmart DB) that shows total USA Warehouse Sales , but excludes the
Los Angeles Stores? In addition, I need my results to be at the Country
level. The problem I can't seem to overcome is filtering on both the
Country AND the city. Any help would be much appreciated.

Thanks,

Bill Adams

How about using VisualTotals, like for Foodmart scenario:

Head(VisualTotals(Hierarchize(Except(Descendants(
[Store].[All Stores].[USA], [Store].[Store City], SELF_AND_BEFORE),
{[Store].[All Stores].[USA].[CA].[Los Angeles]})))) on rows
from Warehouse

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

I have never used VisualTotals, so I will study your example and give
it a try.
Thanks for the excellent example and the quick response !

Bill

Deepak,

Just wanted to let you know your example worked flawlessly and was
exactly what I needed. Thanks again!

Bill