Totals in a pivottable cube

[Jer006]

Hi I have a cube with 3 measures which are added to a owc pivot table as
follows:

..DataAxis.InsertTotal .totals("Gain")
..DataAxis.inserttotal .totals("Loss")
..DataAxis.InsertTotal .totals("Net")

Which works just fine for the subtotals in the control however the grand
totals at the bottom of the control as not the sum of the subtotals but
instead the larger of the previous subtotals!! How can I fix this?

Thanks for all help.

Jeremy.

 

[Alvin Bruney [MVP]]

You may have to write a custom sum routine, have a look at the pivot table
summing functions.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

 

[Jer006]

I rebuilt the cube and the totals are now working just fine, previously it
was summing the subtotals correctly but the grand total was just the maximum
value of the subtotals, now it is correctly showing the grand total as the
summation of the subtotals from the cube. The cube defination did not change
and the code for the control had only minimum changes.

Also one other question, I have a dimension called "As of Date" which is
just a date field in a table where I have removed the All level from, this
works fine in the OWC pivot table version 9 - I correctly do not see an all
option nor am I able to select more than one date at a time. However with no
code changes to the webpage other than the classid of the control if I use
the pivot table from OWC v10, v11 or v12 the all option is available on the
As of Date dimension and more than one date can be selected at a time (no
changes to the cube either!)... Is this something that needs to be set via
the pivot table control as I have tried to exclude the All Member and a few
other things but it is still there and will not go away in these versions!!
Any suggestions?

Thanks

Jeremy.