What on earth is going on here?
Check out this spreadsheet and look at the results in bold and enlarged on both "2003" and "2003 pivot table" (look at the bottom of those sheets)
Why are they different !?
What on earth is going on here?
Check out this spreadsheet and look at the results in bold and enlarged on both "2003" and "2003 pivot table" (look at the bottom of those sheets)
Why are they different !?
Because they are completely different things. One table multiplies the individual order percentages by the previous balance and then adds that to the running total; the pivot table adds all the percentages together for one day and then multiplies the result by the previous balance. There is no comparison in what they're doing.
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks