Unable to filter data copied from pivot table

[devawad]

Dear All,

I have data initially I made pivot table of that then I copied my pivot table in another sheet while copying the same I selected paste special the only value.

Now I am trying to filter it but it is showing only one item instead all product for the filtered customer.

thanks in advance

Dev.

[shukla.ankur281190]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[devawad]

Sir,

have uploaded new sheet plz check.

In the result expected sheetif i select a.k.chemical it should show all the item purchased by him.

Thanks in advance

dev.

[shukla.ankur281190]

1-First go to you pivot table sheet
Go to the navigation tab click on design tab ->>> under layout ->>> choose report layout and click on repeat all items labels....

Thought above step all the items will repeat himself where require, now copy and paste and filter the data.

2 select A column in sheet RESULT EXPECTED SHEET and press control G ->>>click on special ->>>>select blank ->>> this step will select all the blank fields ->>> press = and arrow up key and confirm with control enter not just enter.

Note:- Filter means filter the particular value if there is blank cells then they will be treated by excel as blank not with other name.

Hope this will help you

[devawad]

Dear Sir,

I gone through but in option report layout as well as in field setting there is no option repeat all item labels.


i have attached screen shot in excel for your reference.

Dev

[shukla.ankur281190]

Sorry I didn't see that you have excel 2007... this can be done above 2010 excel version.

You can go with second option.

[devawad]

Dear shukla.ankur281190 ,

It worked, thank you so much,

Dev

[shukla.ankur281190]

Glad to help you please add reputation by clicking star * icon left corner of your screen which post helps you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.