Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multi-selection problem in Excel XP and 2003
We have an Excel report in a dinamic table that gets external data from an
Analisys Services cube. The cube in Analisys Services has many dimentions and measurments, one of them uses the Distinc Count function (agregate function) and the others use the Sum function. In the dinamic table, values are shown rigth when on each page field (dimension in Analisys Services) multi-selection is not checked, that is, if we choose the measure with the distinct count, the right value is shown. However if we check the multi-selection on any page field and we choose any filter to analize, then the value the measure with the disctinct Count shows is "#¡Value!". This is not a problem related to cell format, but to something with Multi-selection inself |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003 Filter Problem | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |