Unanswered: Distinct Count Total problem in Excel XP, OK in Excel 2000
Analysis Services 2000 issue:
When I limit the dimension for the rows or columns in an Excel
Pivot Table the values for the totals of a distinct count measure give a #VALUE error. Exactly the same procedure on exactly the same cube in Excel 2000 goes well.
Is there some bug in the MDX-queries in XP?