filtering with special characters

Good afternoon,

I am having difficulties returning a cube value for a filtered set of data that includes special characters. Simply allowing special characters isn't working - the result is a zero. Please see the attached example. In the pivot table, I can see the info I wish to exclude - all those entries with a zero value in dollars. I can create a filter to identify chains to exclude:

=NL("Filter","Sales","[Chain].[Chain]","DataSource=","JetReports","[Posting Date].[Date YQMD].[Month]","2014 May","[Measures].[dollars]","<>0")

However when I use this filter to return a cube value, I get nothing. There is an invalid filter.

=NL("CubeValue","Sales","[Measures].[volume]","DataSource=","JetReports","[Posting Date].[Date YQMD].[Month]","2014 May","[Chain].[Chain]","@@"&NL("Filter","Sales","[Chain].[Chain]","DataSource=","JetReports","[Posting Date].[Date YQMD].[Month]","2014 May","[Measures].[dollars]","<>0"))

Anyone have a suggestion?

KristenTNA

• example.xlsx