I don't have Power Pivot, so I can't create my own formulas in pivot tables.
My source data contains things that people input (days and initials) and cells that calculate things (time between days, etc.) The cells that calculate things are Team1_WD, Team2_WD, and Status. I have pivot tables that use data in the calculated fields. My question is, are there best practices in organizing this data set? Should I keep all the calculated columns off to one side? Is there a better way to set this up? Thanks.
My source data contains things that people input (days and initials) and cells that calculate things (time between days, etc.) The cells that calculate things are Team1_WD, Team2_WD, and Status. I have pivot tables that use data in the calculated fields. My question is, are there best practices in organizing this data set? Should I keep all the calculated columns off to one side? Is there a better way to set this up? Thanks.