Hoping all you Analytics folks will have an easy answer for this...
My finance team wants a cash flow dashboard that includes a 3 year average of cash received. I'm in the finance cube and I've got a pivot table started but my three-year average isn't quite working out. I know it's not showing accurate info for each month but I can't figure out why. I thought to use debit amount because that's when money goes into a GL so I have:
Any thoughts? Or has anyone accomplished this with success? Or am I WAY off base in my thinking? HELP!
Following.