Totals issue for manual expression as report column

[JohnV]

I am having a totals issue for an IE web pivot report based on cubes (using
OWC 10).

I could get totals for all data fields those come from Olap cubes except for
a manual report column ("Loss Constant" as shown in the below xml). This
one field should be a constant and should be a manual entry to the following
pivot table xml.

I am wondering if there is anyway that I could get total for this column by
making changews within this xml. I appreciate if I could get help from
anybody experienced is highly appreciated and relieves me..

Thanks
JohnV

<xml xmlns:x="urn:schemas-microsoft-comffice:excel">
<xivotTable>
<x:OWCVersion>10.0.0.4109 </x:OWCVersion>
<x:CubeProvider>msolap.2</x:CubeProvider>
<xataMember>Store Chain Reporting</xataMember>
<x:Name>Microsoft Office PivotTable 10.0</x:Name>
<xivotField>
<x:Name>Store Name</x:Name>
<x:SourceName>[Store Chain].[Store Name]</x:SourceName>
</xivotField>
<xivotField>
<x:Name>Day Ending</x:Name>
<x:SourceName>[Date].[Day Ending]</x:SourceName>
<x:Orientation>Row</x:Orientation>
</xivotField>
<xivotField>
<x:Name>Sales Adjusted</x:Name>
<xLName>Sales Total</xLName>
<x:Orientation>Data</x:Orientation>
<x:Expression>([Store Chain].[Sales].[Sales Adjusted],[Measures].[Net
Sales])</x:Expression>
</xivotField>
<xivotField>
<x:Name>Loss Constant</x:Name>
<xLName>Loss Constant Value</xLName>
<x:Orientation>Data</x:Orientation>
<x:Expression>21488</x:Expression>
</xivotField>
</xivotTable>
</xml>

Report.
=========================
11/1/06 6 PM 528000 21488
11/2/06 5 PM 235000 21488
11/3/06 6 PM 420000 21488
....

Grand Total 1183000 21488

===========================

 

[JohnV]

Still hope to get some help on this

"JohnV" wrote in message news:[email protected]...

 

[Alvin Bruney [MVP]]

Have a look at custom functions in the pivot table object hierarchy, you can
set a fieldset and automatically sum it.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black book on Amazon and
www.lulu.com/owc
Look out for Excel Services for .NET coming soon

Still hope to get some help on this

"JohnV" wrote in message news:[email protected]...

I am having a totals issue for an IE web pivot report based on cubes
(using OWC 10).

I could get totals for all data fields those come from Olap cubes except
for a manual report column ("Loss Constant" as shown in the below xml).
This one field should be a constant and should be a manual entry to the
following pivot table xml.

I am wondering if there is anyway that I could get total for this column
by making changews within this xml. I appreciate if I could get help from
anybody experienced is highly appreciated and relieves me..

Thanks
JohnV

<xml xmlns:x="urn:schemas-microsoft-comffice:excel">
<xivotTable>
<x:OWCVersion>10.0.0.4109 </x:OWCVersion>
<x:CubeProvider>msolap.2</x:CubeProvider>
<xataMember>Store Chain Reporting</xataMember>
<x:Name>Microsoft Office PivotTable 10.0</x:Name>
<xivotField>
<x:Name>Store Name</x:Name>
<x:SourceName>[Store Chain].[Store Name]</x:SourceName>
</xivotField>
<xivotField>
<x:Name>Day Ending</x:Name>
<x:SourceName>[Date].[Day Ending]</x:SourceName>
<x:Orientation>Row</x:Orientation>
</xivotField>
<xivotField>
<x:Name>Sales Adjusted</x:Name>
<xLName>Sales Total</xLName>
<x:Orientation>Data</x:Orientation>
<x:Expression>([Store Chain].[Sales].[Sales Adjusted],[Measures].[Net
Sales])</x:Expression>
</xivotField>
<xivotField>
<x:Name>Loss Constant</x:Name>
<xLName>Loss Constant Value</xLName>
<x:Orientation>Data</x:Orientation>
<x:Expression>21488</x:Expression>
</xivotField>
</xivotTable>
</xml>

Report.
=========================
11/1/06 6 PM 528000 21488
11/2/06 5 PM 235000 21488
11/3/06 6 PM 420000 21488
...

Grand Total 1183000 21488

===========================