Pivot App is just clocking and not creating a pivot table for me

Jason St.

I am trying to create a simple pivot table that shows project planned spend and project actual spend by month from a project sheet. My Planned Spend and Actual Spend columns are calculated in the worksheet (each row calculates task cost by multiplying "resource hours" x "resource cost") and I added a column to indicate the month by a number that the task occurred (Jan = "1"). Seems simple enough, not sure why I can't get it to work and the app just clocks after I hit "Create". Any thoughts?

Example of what the pivot table would look like:

Jan Feb Mar …….

Planned Cost 100 100 100

Actual Cost 94 0 0

Thanks!!

Jason St.

	Jan	Feb	Mar	Apr
	Planned Cost	Jan	100	Feb	100	Mar	100	Apr	100
	Actual Cost	Jan	94	Feb		Mar		Apr

Better table view….

Humashankar

Hi @Jason St.

Can you confirm the exact data types in your Planned Spend and Actual Spend columns?
Are they pure numeric values or do they contain any text or formatting?

Regards

Jason St.

Humashankar - thanks for responding - I was able to figure out the issue. It was a "user error" on how I was using the pivot app. I figured out if I leave the "Columns" selection blank it ran with no issues.