RE: MDX FILTER PROBLEM

#1

Hello Mon,
please filter with 0.7. the Percentage is just
formatting like it is in Excel.

HTH
Jörg

"Mon" wrote:

Quote:

Hi ,
1> I have a calculated measure which is type percentage ,
but when I filter it [measures].[Salepercent] < 70
it ignores this filter and even shows the record
70 , please let me know how to filter on percentage type
of field.
2> I have to filter on 4 condition like wise
profit > 10000 , profit < 20000 and
SalePercen > 50% , salepercent < 70 % how do i do this.

Thanks in Advance,
Mon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: MDX FILTER PROBLEM

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

RE: MDX FILTER PROBLEM - 06-17-2004 , 02:43 PM