Urgent - OWC Pivot Table Calculated Total doesn't work correctly

[frog314]

Microsoft Developer Team,
I use OWC Pivot Table to create report based on OLAP (provider). I have
created calculated total :
iif(isempty([Measures].[Avalibility [%]]]),null,iif([Measures].[Avalibility
[%]]]=0,1,null)) and it doesn’t work correctly – when I used only this
calculated total on the data file I cannot se any rows but when I use it with
another measure everything is okay.

What I really want to do? I just want to filter rows where
[Measures].[Avalibility [%]]]=0.

Do you have any ideas how to do that (when I use MSSQL OLAP Provider)? Or
what I do wrong?

Sincerely,
Jarek Maciag
Poland

Nick: frog314


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...rosoft.public.office.developer.web.components