Showing Cumulative Data & Day's Data in Pivot

arunjhalani

Board Regular
Joined
Oct 8, 2002
Messages
121
I have linked My Excell sheet to Oracle Database and getting the Data from there Datewise. I need to Have only three columns in the pivot giving me the Todays' Date and Cumulative upto date (Data has been grouped Monthly.
Next day when I Refreshed my Pivot, The Date should automatically pick the System Date and Cumulative figure shoul also be Refreshed.

Can Anyone please help me out of this ??
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
On 2002-10-10 11:15, Mark W. wrote:
Describe the columns and rows that you're retrieving from your Oracle database.
Dates, Month, Despatch,Product Code,Product Description
I need cumulative for the Month, ence this is placed in Page Field. Dates in the Column Field & Product Code & Product Description in the Row fileds, Despatch is the Data Field.
 
Upvote 0
Like this?...
Book1
ABCDEFGHIJKLM
1DateMonthDispatchProductCodeMonthOct
210/1/2002Oct46A
310/5/2002Oct11ASumofDispatchDate
410/6/2002Oct55AProductCode10/1/200210/5/200210/6/200210/10/200210/12/200210/16/2002
510/10/2002Oct80AA4657112192245305
610/12/2002Oct53A
710/16/2002Oct60A
8
Sheet1


I just double-clicked the 'Sum of Dispatch' field button, clicked the [ Options>> ] button, and set it to "Running Total in" with 'Date' as the base field.
 
Upvote 0
Ya Exactly
But I had Directly feth the data in the Pivot.
My Requirement is to have the Two Columns in the Pivot Field in which One is Current Date data and the other is the Cumulative one.

Thanks in Advance
 
Upvote 0

Forum statistics

Threads
1,226,283
Messages
6,190,048
Members
453,591
Latest member
plengeb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top