Re: MDX Calculated Cells (Excel Pivot table)

#1

Quote:

When [Measures].[Qty] is negative then the current line do not come in
Pivot table,
but the value for [Measures].[Qty] is in the "total" for the items in the
Pivot table, which I do not whant!

I am not sure I understand what you are asking. Your formula says that when
Measures.Qty is negative - return NULL. Do you see different result ?

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

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

Re: MDX Calculated Cells (Excel Pivot table)

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

Re: MDX Calculated Cells (Excel Pivot table) - 02-25-2004 , 01:53 PM