MDX Query -
08-26-2004
, 07:08 AM
Hi
Can anybody please help me to write a query where i can compare
the data of the measures of two dates,show the difference between them
and also the %change.
asset is one dimension and i have 10 measures.customer selects two
dates and he wants that his assets perfomance between two dates ,the
change and the change%.
e.g the dataset should be like;-
Assets Balance COA ROI Holding
stocks (Date1,date2,change,change%)
Mutual funds
cash
securities
bonds |