Hi Experts,
Request you to help to resolve this below query.
I have put pivot for one data and it contains employee code and name. I
tried option multiple consolidation ranges while put a pivot. Name also
consider as value. Need to show employee code as well as name in pivot,
also is it possi
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,
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
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
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
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
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
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
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
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
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
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
12 matches
Mail list logo
