ched file saved in excel 2003.
>
> Regards
>
> Kantilal
>
> -- Forwarded message --
> From: alisha malhotra
> Date: Wed, Dec 15, 2010 at 6:44 PM
> Subject: Re: $$Excel-Macros$$ cumulative sum in pivot table
> To: excel-macros@googlegroups.com
>
Hi Alisha,
Find attached file saved in excel 2003.
Regards
Kantilal
-- Forwarded message --
From: alisha malhotra
Date: Wed, Dec 15, 2010 at 6:44 PM
Subject: Re: $$Excel-Macros$$ cumulative sum in pivot table
To: excel-macros@googlegroups.com
Hi Kantilal,
Thanks for your
Hi Kantilal,
Thanks for your reply. Could you please save this attachment in excel 2003?
Is that possible in excel 2003?
Regards,
Alisha
On Thu, Dec 9, 2010 at 5:56 AM, Kantilal Badale
wrote:
>
>
> check the attachment see if it helps .
>
> Kantilal Badale
>
>
>
>
> On Tue, Dec 7, 2010 at 4:06
Hi,
File by Mr Kantilal Badale is working as per your requirements. In
case you find problem in understanding how it is working please click
on any cell in column marked Sum of Sale 2 and right click. Select
"Value Field Setting.." > Select summarize by Sum and in Show Value as
tab select Running
check the attachment see if it helps .
Kantilal Badale
On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra wrote:
> Hi Group,
>
> I have one pivot table. In that I want to show the cumulative sum.
> e.g.
> Qtr1 sale:- 10 units
> Qtr2 sale:- 20 units
> Qtr3 sale:- 10 units
> Qtr4 sale:- 30 unit
Hi Alisha,
It would be really helpful if you can share a dump file.
Regards,
Deepak Rai
On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra wrote:
> Hi Group,
>
> I have one pivot table. In that I want to show the cumulative sum.
> e.g.
> Qtr1 sale:- 10 units
> Qtr2 sale:- 20 units
> Qtr3 sale:-
Hi Group,
I have one pivot table. In that I want to show the cumulative sum.
e.g.
Qtr1 sale:- 10 units
Qtr2 sale:- 20 units
Qtr3 sale:- 10 units
Qtr4 sale:- 30 units
now i want to show the sale of qtr1 and qtr2 i.e. 30 units after qtr2 and
similarly after qtr3 cumulative sum of qtr1,2 and 3 i.e.