Hi Rakesh, See if it helps...
Regards,
Jaideep Panchal
New Delhi
----- Original Message -----
From: rakesh kumar
To: excel-macros@googlegroups.com
Sent: Sunday, April 03, 2011 1:44 PM
Subject: Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range
Hi Umesh/Group members,
I am attaching the sample data. I know if I take gender for column it'll
solve the problem, but for some reason I don't wish to add any field in the
column..
Thanks !
On Fri, Apr 1, 2011 at 7:07 PM, Umesh Dev <umesh.d...@gmail.com> wrote:
Hi Rakesh,
can you attach the excel sheet
Regards
Umesh Dev
On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar <rakeshshail2...@gmail.com>
wrote:
Hi ! Group members,
I have a pivot table, which shows 5 income groups in row Range and their
counts. However, when I apply a filter it leaves 3 income groups in the row
range as other two groups don't match the filter criteria. I want the pivot
table to keep all five groups and if a group doesn't match the filter criteria
it should show 0 or anything else will just do. any idea ???
Thanks !!
--
Rakesh kumar khowal
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Rakesh kumar khowal
+91 9868532105
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
test_x.xls
Description: MS-Excel spreadsheet
