Data Sorting: Pivot Table

[ngopal13]

Hi MrExcel,

I am working on creating pivot tables. I came across weird problem during sorting of the data. I have numbers and some text along with #N/A in the cell. While I am doing the sorting, I can see only few data is sorting then #N/A is coming in between then sorting again. So in nutshell its sorting half then again half.

Could anyone help me in finding a solution for this? I really appreciate the help.

Best,
Nimsh

 

[scottsen]

Are you using Power Pivot, or just normal Excel pivot tables? If the latter, you may get more traction on the general excel forum.

This isn't a problem I have seen...

 

[ngopal13]

Yes I am using excel pivot tables. Can yous send me the link to the specific general excel forum? Thanks

Are you using Power Pivot, or just normal Excel pivot tables? If the latter, you may get more traction on the general excel forum.

This isn't a problem I have seen...

 

[scottsen]

Excel Questions