Measure show only <> 0 -
01-23-2006
, 08:25 AM
Hi,
Newbie on creating reports with OLAP, Pls help.
From Excel pivot table report, how can i filter only
transaction where my measure "discount" shows only
values <> 0?
When i look into my fact table and checked discount field, values were
either greater than 0 or NULL.
Does OLAP automatically convert 'NULL' measures to 0 instead of empty ?
Please advice. thanks.
*** Sent via Developersdex http://www.developersdex.com *** |