subject:"$$Excel\-Macros$$ Problem in pivot table"

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, 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 relevant..
>>
>>
>> *With regards,**Pravin Gunjal*
>> *Mobile: 77100 *
>> *97250*
>>
>>
>>
>>
>> On Mon, Apr 25, 2016 at 12:41 PM, Satendra kumar <
>> satendrakuma...@gmail.com> 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 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 it shows many names and while selection on
 them nothing is getting displayed. For Example: "DR . ABHIJEET PATAK"

 Can you please let me know how is it happening? File attached.

 Thanks in anticipation.

 Regards
 Pravin Gunjal

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at https://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>>>
>>> --
>>> Thanks & Regards
>>> Satendra Kumar
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/excel-macros/ZmIyRfDocaM/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum

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 relevant..
>
>
> *With regards,**Pravin Gunjal*
> *Mobile: 77100 *
> *97250*
>
>
>
>
> On Mon, Apr 25, 2016 at 12:41 PM, Satendra kumar <
> satendrakuma...@gmail.com> 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 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 it shows many names and while selection on
>>> them nothing is getting displayed. For Example: "DR . ABHIJEET PATAK"
>>>
>>> Can you please let me know how is it happening? File attached.
>>>
>>> Thanks in anticipation.
>>>
>>> Regards
>>> Pravin Gunjal
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Thanks & Regards
>> Satendra Kumar
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/excel-macros/ZmIyRfDocaM/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.

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 it shows many names and while selection on them
> nothing is getting displayed. For Example: "DR . ABHIJEET PATAK"
>
> Can you please let me know how is it happening? File attached.
>
> Thanks in anticipation.
>
> Regards
> Pravin Gunjal
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Thanks & Regards
Satendra Kumar

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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 koul.ash...@gmail.com 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 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 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 10:27 AM, ashish koul koul.ash...@gmail.comwrote:

 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 category that is
 wrong.

 I am sending you the file as attachment. Please help me in creating the
 pivot table.

 *Please tell me how to use formula in pivot table also*.

 Waiting for your reply.

 Thanks  Regards,
 Alisha


 --

 --
 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




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 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




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


  --

 --
 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

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 category that is wrong.

 I am sending you the file as attachment. Please help me in creating the
 pivot table.

 *Please tell me how to use formula in pivot table also*.

 Waiting for your reply.

 Thanks  Regards,
 Alisha


  --

 --
 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




-- 
Hello,





This is
Yash

Bye...

-- 
--
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


Book1 (version 1).xls
Description: MS-Excel spreadsheet

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 10:27 AM, ashish koul koul.ash...@gmail.com wrote:

 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 category that is
 wrong.

 I am sending you the file as attachment. Please help me in creating the
 pivot table.

 *Please tell me how to use formula in pivot table also*.

 Waiting for your reply.

 Thanks  Regards,
 Alisha


 --

 --
 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




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


  --

 --
 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


Book1 (2).xls
Description: MS-Excel spreadsheet

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 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 10:27 AM, ashish koul koul.ash...@gmail.comwrote:

 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 category that is
 wrong.

 I am sending you the file as attachment. Please help me in creating the
 pivot table.

 *Please tell me how to use formula in pivot table also*.

 Waiting for your reply.

 Thanks  Regards,
 Alisha


 --

 --
 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




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 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




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
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

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 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 10:27 AM, ashish koul koul.ash...@gmail.comwrote:

 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 category that is
 wrong.

 I am sending you the file as attachment. Please help me in creating the
 pivot table.

 *Please tell me how to use formula in pivot table also*.

 Waiting for your reply.

 Thanks  Regards,
 Alisha


 --

 --
 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




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 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


-- 
--
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

$$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.

*Please tell me how to use formula in pivot table also*.

Waiting for your reply.

Thanks  Regards,
Alisha

-- 
--
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


Book1 (version 1).xls
Description: MS-Excel spreadsheet

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 category that is wrong.

 I am sending you the file as attachment. Please help me in creating the
 pivot table.

 *Please tell me how to use formula in pivot table also*.

 Waiting for your reply.

 Thanks  Regards,
 Alisha


 --

 --
 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




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
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


Book1.xls
Description: MS-Excel spreadsheet

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

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

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

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

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

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

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

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

$$Excel-Macros$$ Problem in pivot table

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

10 matches

Site Navigation

Mail list logo

Footer information