M moizs New Member Aug 5, 2012 #1 Hello I have made a pivot table which party wise sales details on daily basis, I want to group it on monthly basis but I am unable to do.
Hello I have made a pivot table which party wise sales details on daily basis, I want to group it on monthly basis but I am unable to do.
Hui Excel Ninja Staff member Aug 5, 2012 #2 Moizs Firstly, Welcome to the Chandoo.org forums. With your pivot table check that the source Dates are Dates and not text Check there is no invalid entries in the dates field ie: Text, spaces or blank entries
Moizs Firstly, Welcome to the Chandoo.org forums. With your pivot table check that the source Dates are Dates and not text Check there is no invalid entries in the dates field ie: Text, spaces or blank entries
M moizs New Member Aug 6, 2012 #4 Hi Hui Please find below the link of workbook it has 2 pivot tables In the first one I am unable to group the dates. The pivot table i need a column which shows the percentage of grand total. https://dl.dropbox.com/u/96239378/pivot%20table.xlsx Regards Moiz
Hi Hui Please find below the link of workbook it has 2 pivot tables In the first one I am unable to group the dates. The pivot table i need a column which shows the percentage of grand total. https://dl.dropbox.com/u/96239378/pivot%20table.xlsx Regards Moiz
