bobhc Excel Ninja May 20, 2013 #2 Good day hashmat Welcome to Chandoo Do you mean by the field table? A bit more information as to what you need would help. Pivot Table..Pivot Chart?? It is always better to upload a sample so that we can see the problem.
Good day hashmat Welcome to Chandoo Do you mean by the field table? A bit more information as to what you need would help. Pivot Table..Pivot Chart?? It is always better to upload a sample so that we can see the problem.
Debraj Excel Ninja May 20, 2013 #3 Hi Hasmat.. Welcome to the forum.. Did you ever tried.. * Right Click Pivot Table * Pivot Table Options.. * Display > * Classic Pivot Table Layout(Enables dragging of Fields in the grid) By dragging any field (rows/column) you can manually Re-Arrange your data Field.. By The way if you are not asking for sorting any field.. then SORT by Custom field is another thing you need to learn.. Regards, Deb
Hi Hasmat.. Welcome to the forum.. Did you ever tried.. * Right Click Pivot Table * Pivot Table Options.. * Display > * Classic Pivot Table Layout(Enables dragging of Fields in the grid) By dragging any field (rows/column) you can manually Re-Arrange your data Field.. By The way if you are not asking for sorting any field.. then SORT by Custom field is another thing you need to learn.. Regards, Deb