Help With Pivot for getting cumulative data!

K

Karthik-Excelsior

Active Member
Joined
Mar 4, 2011
Messages
313
I've a small but an urgent question re. Pivot tables. How to pivot a table with cumulative values? I've to look at the week over week performance stats, and I'm using Pivots to see what has been the performance in Wk1 (10 units), Wk2 (15 units), Wk3 (8 units), etc. However, what I would like to see is the cumulative number for each of the weeks Wk1 (10 units), Wk2 (25 Units), Wk3 (33 units), etc. Is that poss? If so, how? Thx a bunch in advance!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You must log in or register to reply here.

Similar threads

K
  • Solved
vlookup product & certain quantity in a cumulative pivot table and return the date (header of that pivot table
Replies
3
Views
505
awoohaw
awoohaw
D
  • Solved
Pivot Table Averages incorrect due to 0 values in raw data
Replies
1
Views
520
dianne_g
D
R
  • Question
PIVOT Table help
Replies
0
Views
129
RattlingCarp3048
R
T
  • Question
Returning all data despite duplicate values
Replies
0
Views
465
Tommy1115
T
ajjava
  • Question
Procedure to find MAX VALUE in a SPECIFIC pivot table value field, in the case of MULTIPLE pivot table value fields
Replies
0
Views
2K
ajjava
ajjava

Forum statistics

Threads
1,221,417
Messages
6,159,789
Members
451,589
Latest member
Harold14

Share this page

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