Hello,
I am using "Microsoft pivot table 11.0" in Microsoft web component. We have a oracle table having three follwing columns:
City varchar(20)
Date date
value number(10)
CITY DATE VALUE
-----------------------------------------------
A 01-02-2012 10
A 01-03-2012 5
B 01-02-2012 23
B 01-03-2012 9
C 01-02-2012 13
I am using an "OLE DB 4.0 provider" to connect it in Microsoft pivot table 11.0" in Microsoft web component and want to show following report by same.
DATE 01-02-2012 01-03-2012 GRAND TOTAL
-------------------------------------------------------------------------------------------------------
CITY
-------------------------------------------------------------------------------------------------------
A 10 5 15
B 23 9 32
C 13 13
-------------------------------------------------------------------------------------------------------
GRAND TOTAL 46 14 60
------------------------------------------------------------------------------------------------------
To build this report I can get other part but unable to show the vertically/horizontally the "GRAND TOTAL" part. These are either showing the count total or in expansion/collapse mode showing the distinct values shows as below:
DATE 01-02-2012 01-03-2012 GRAND TOTAL
-------------------------------------------------------------------------------------------------------
CITY
-------------------------------------------------------------------------------------------------------
A 10 5
B 23 9
C 13
-------------------------------------------------------------------------------------------------------
GRAND TOTAL 10 5 15
23 9 32
13 13
------------------------------------------------------------------------------------------------------
Request to anyone please provide a resolution of same. I am accesable in : (e-mail address removed) for these resolution.
I am using "Microsoft pivot table 11.0" in Microsoft web component. We have a oracle table having three follwing columns:
City varchar(20)
Date date
value number(10)
CITY DATE VALUE
-----------------------------------------------
A 01-02-2012 10
A 01-03-2012 5
B 01-02-2012 23
B 01-03-2012 9
C 01-02-2012 13
I am using an "OLE DB 4.0 provider" to connect it in Microsoft pivot table 11.0" in Microsoft web component and want to show following report by same.
DATE 01-02-2012 01-03-2012 GRAND TOTAL
-------------------------------------------------------------------------------------------------------
CITY
-------------------------------------------------------------------------------------------------------
A 10 5 15
B 23 9 32
C 13 13
-------------------------------------------------------------------------------------------------------
GRAND TOTAL 46 14 60
------------------------------------------------------------------------------------------------------
To build this report I can get other part but unable to show the vertically/horizontally the "GRAND TOTAL" part. These are either showing the count total or in expansion/collapse mode showing the distinct values shows as below:
DATE 01-02-2012 01-03-2012 GRAND TOTAL
-------------------------------------------------------------------------------------------------------
CITY
-------------------------------------------------------------------------------------------------------
A 10 5
B 23 9
C 13
-------------------------------------------------------------------------------------------------------
GRAND TOTAL 10 5 15
23 9 32
13 13
------------------------------------------------------------------------------------------------------
Request to anyone please provide a resolution of same. I am accesable in : (e-mail address removed) for these resolution.