Re: $$Excel-Macros$$ Problem in Pivot Table

2016-04-25 Thread Pravin Gunjal
Perfect... Thanks! *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, Apr 25, 2016 at 1:17 PM, Abhishek Jain wrote: > Try this: > >1. Right-click a cell in the pivot table >2. Click on PivotTable options >3. Click on the Data tab >4. In the Retain Items section,

Re: $$Excel-Macros$$ Problem in Pivot Table

2016-04-25 Thread Abhishek Jain
Try this: 1. Right-click a cell in the pivot table 2. Click on PivotTable options 3. Click on the Data tab 4. In the Retain Items section, select None from the drop down list. 5. Click OK, then refresh the pivot table. On Mon, Apr 25, 2016 at 12:54 PM, Pravin Gunjal wrote: > Not

Re: $$Excel-Macros$$ Problem in Pivot Table

2016-04-25 Thread Pravin Gunjal
Not relevant.. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Mon, Apr 25, 2016 at 12:41 PM, Satendra kumar wrote: > Hi, > > you can check name spelling or space. > > thanks > satendra > > On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal wrote: > >> Hi Friends, >> >> I got an er

Re: $$Excel-Macros$$ Problem in Pivot Table

2016-04-25 Thread Satendra kumar
Hi, you can check name spelling or space. thanks satendra On Mon, Apr 25, 2016 at 12:32 PM, Pravin Gunjal wrote: > Hi Friends, > > I got an error while arranging the data in pivot table. > > The list has only 34 names common in Data Sheet while when I click on Row > Lable Filter in Pivot Sheet

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-18 Thread alisha malhotra
Hi Ashish, Thanks for your help. Regards, Alisha On Sat, Apr 16, 2011 at 9:49 AM, ashish koul wrote: > its because its showing subtotals . hide them thats it . keep the cursor on > vgood right click and unselect subtotal ,same for good etc. > > > > > On Fri, Apr 15, 2011 at 11:32 PM, alisha ma

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-15 Thread chandrabhushan prasad
plz put up all poor, avg, good, very good in one column then create pivot table On Fri, Apr 15, 2011 at 11:32 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi Ashish, > > I have made the pivot table using the layout as yours layout. But my pivot > is little bit complicated.Why is th

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-15 Thread ashish koul
its because its showing subtotals . hide them thats it . keep the cursor on vgood right click and unselect subtotal ,same for good etc. On Fri, Apr 15, 2011 at 11:32 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi Ashish, > > I have made the pivot table using the layout as yours

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-15 Thread alisha malhotra
Hi Ashish, I have made the pivot table using the layout as yours layout. But my pivot is little bit complicated.Why is that so happening?. Why did you use employee code in data instead of count of poor or count of avg etc.? I am sending you the attachment. Regards, Alisha On Fri, Apr 15, 2011 at

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-15 Thread Yogesh Gohil
Like this??? On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi, > > I want to create one pivot table. In this, *I want to calculate the number > of employees in Poor, Avg, good, and very good.* > But it is showing the same no. of employees in each catego

Re: $$Excel-Macros$$ Problem in pivot table

2011-04-14 Thread ashish koul
see if it helps On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi, > > I want to create one pivot table. In this, *I want to calculate the number > of employees in Poor, Avg, good, and very good.* > But it is showing the same no. of employees in each cat

$$Excel-Macros$$ Problem in pivot table

2011-04-14 Thread alisha malhotra
Hi, I want to create one pivot table. In this, *I want to calculate the number of employees in Poor, Avg, good, and very good.* But it is showing the same no. of employees in each category that is wrong. I am sending you the file as attachment. Please help me in creating the pivot table. *Pleas