August 7, 2013 at 4:15 am
Hello Experts,
Can someone help on MDX query please? It’s very urgent
We are getting following result while building the MDX query for report:
BrandCountryCurrencyFirst Invoice DateRevenue
XXUKEUR201101 Null
XXUKGBP201305 4256
On row side we have to make the cross join with Brand, Country and Currency but while making the cross join with currency we are getting two different rows for same Brand and country because of that we are getting two different First Invoice dates (201101 and 201305) but actually First Invoice date for brand XX is only 201101 (First row) , so is there any possible way by which we can update the value of 2nd row First Invoice Date by the value of First row in MDX query please?
Note: - It is also important to take currency to get the Currency Rate to convert Revenue
August 8, 2013 at 2:12 pm
Where is the MDX query?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply