Pivot table - Sum on the row and Average on the column summaries.

[Saiku]

Hi:

I need to show sum as the row aggregate and a simple average as the
column aggregate on my pivot table. Something like -

-2007 Category1 Category2 Category3 Total
-Jan
-1 10 20 30 60(Sum)
-2 .. .. .. ..
.. .. .. .. ..
Total Average Average Average Average

I am using OWC11+Analysis Services+ASP.NET+.NET Webservices (to
service the grids to my website)

Greatly appreciate any assistance

Thanks
Sai

 

[Saiku]

Hi:

I need to show sum as the row aggregate and a simple average as the
column aggregate on my pivot table. Something like -

-2007 Category1 Category2 Category3 Total
-Jan
-1 10 20 30 60(Sum)
-2 .. .. .. ..
.. .. .. .. ..
Total Average Average Average Average

I am using OWC11+Analysis Services+ASP.NET+.NET Webservices (to
service the grids to my website)

Greatly appreciate any assistance

Thanks
Sai

No thoughts? or is my question ambiguous?

thanks,

 

[Alvin Bruney [MVP]]

Have you tried using the sum function for the fieldset?

--
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