Mr. Daniel I have tried to apply Pivot Table on the Base Data but could not succeed as the pop up message showing "Data source reference is not valid". Please help Rajeev On Sun, Sep 20, 2009 at 1:25 PM, Daniel <dcolarde...@free.fr> wrote:
> Sorry Here it is. > > > -----Original Message----- > > From: excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] On Behalf Of HumanJHawkins > > Sent: samedi 19 septembre 2009 23:28 > > To: MS EXCEL AND VBA MACROS > > Subject: $$Excel-Macros$$ Re: How to Show Count of Zero in Pivot Table > > > > > > Thanks Daniel, but I'm not seeing an attached file. > > > > FYI, I have a work-around. I'm mostly just trying to learn how you can > make > > Excel do this. It seems like it should be a normal operation. I was > surprised it > > wasn't the default behavior. > > > > On Sep 19, 7:27 am, "Daniel" <dcolarde...@free.fr> wrote: > > > Have a look at the attaché file. > > > I added 3 columns to the data (see formulas in the columns) HTH Daniel > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: excel-macros@googlegroups.com [mailto:excel- > > > > mac...@googlegroups.com] On Behalf Of HumanJHawkins > > > > Sent: vendredi 18 septembre 2009 23:24 > > > > To: MS EXCEL AND VBA MACROS > > > > Cc: jhawk...@locutius.com > > > > Subject: $$Excel-Macros$$ How to Show Count of Zero in Pivot Table > > > > > > > I have a table that has this structure: > > > > > > > ThingID ThingGrouping ThingStatus > > > > 1 A Done > > > > 2 A Started > > > > 3 B Started > > > > 4 B NotStarted > > > > > > > It is easy to make a pivot Table that shows a count of things in > > > > groups at > > > a > > > > status. But it doesn;t show counts of zero... The result currently > > > > looks > > > like: > > > > > > > Group Status Count > > > > A Started 1 > > > > A Done 1 > > > > B NotStarted 1 > > > > B Started 1 > > > > > > > However, what I need (because there are actually thousands of rows > > > > and it > > > is > > > > much more complicated) is to have a result that looks like this: > > > > > > > Group Status Count > > > > A NotStarted 0 > > > > A Started 1 > > > > A Done 1 > > > > B NotStarted 1 > > > > B Started 1 > > > > B Done 0 > > > > > > > Can anyone help? > > > > Thanks in advance. > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
