Hello,
First post here. I have several financial forecasting spreadsheets that I use, generally I enter the data in a table, and then pivot on the tale to get my forecast inputs. I use the date field as the column headings. I have noticed that often in the pivot table, the dates will not group at all, or group with one incorrect outlier. Why does his happen and what are solutions? Thanks for any help.
First post here. I have several financial forecasting spreadsheets that I use, generally I enter the data in a table, and then pivot on the tale to get my forecast inputs. I use the date field as the column headings. I have noticed that often in the pivot table, the dates will not group at all, or group with one incorrect outlier. Why does his happen and what are solutions? Thanks for any help.
