Very tricky MDX (combine VisualTotals with Order) -
06-03-2004
, 09:56 AM
Hello,
We are using the following construction in a select:
{
Order(
VisualTotals(
filter(
Descendants(somedimensionmember),
abitofcomplexlogic
),
"visualtotal of *"),
[Measures].somevalue, DESC)
} on rows
Will the Order() function use the "VisualTotals" version of
"somevalue" or the exact value ? Of course we would like to get the
order on the report according to the visual value. Is this possible ?
I ask because we get strange results (ordering not ok, the hierarchy
seems to be lost too).
Many thanks,
Tom |