Dear all,

I've build up a simple cube with a measure "salesamount" and at
time-dimension "salesdate" out of one fact-table. In the time-dimension there
are only the levels year and month.

When I put the data from the cube to an Excel 2000 pivot-table I see the
right totals for all the years. If I drilldown the months I still have the
right totals for the months. But when I analyze for example only the january
of every the grand total of the pivot-table and the totals per year are not
changing. This is also misleading to the users.
What I found out is, that Excel 2000 seems not support subtotals for hidden
page items. Do I have to live with this or is there something I can configure
in the cube.

Best regards
Oliver