Daily Difference in Pivot Table

Hey everyone,

I have a list of, say, the number of vegetables (potatoes, turnips, carrots etc...) sold at my grocery store every day.

I'm trying to use a pivot table to summarize the daily difference for each vegetable. Right now I have to create columns for each vegetable and calculate the daily difference, and then import all of this in to a pivot table. This takes a while and doesn't really work well...

Is there any way to look at the difference in a pivot table without creating a new column in the original table? I tried using calculated fields but they would only let me check the difference between different vegetables and not one vegetable against itself?


Many thanks,
AR

Yes, there is an option to do this in the Pivot Table. In the "Field Value Settings" box, "Show Value as" tab, you can select "Difference from" and "Previous" to get the daily change.

SAE

Perfect, gracias!