Hi,
I'm attemting to do a transaction analysis using PP of how many transactions occured per day. I have my data linked to a calendar table but when I choose the calendar columns of Year, month and day the pivot table is blank. I added calculated columns in my Budget data table for year month and day and when I choose them for the rows then the data shows up. I'm totally confused!
I have uploaded a copy of my spreadsheet here - https://dl.dropboxusercontent.com/u/45530070/PI Transaction Analysis 2013-08-10.xlsx
The challenge is that I have 6 other data tables linked to the calendar lookup table that I want to show in columns such that over all the different types of transactions I will get a grand total of how many transactions occurred per day.
I'm relatively new to PP and was hoping this would be an easy start to learning about this powerful tool. I have watched a lot of you tube and also bought Rob Collier's book and for some reason I'm totally stumped. Very frustrating when I know it's probably something really silly that I'm NOT doing right!
I'm ready to give up and do the analysis within excel.
I'm desperate! Please help me stay on the PowerPivot line!
Thanks in advance,
Suzi
I'm attemting to do a transaction analysis using PP of how many transactions occured per day. I have my data linked to a calendar table but when I choose the calendar columns of Year, month and day the pivot table is blank. I added calculated columns in my Budget data table for year month and day and when I choose them for the rows then the data shows up. I'm totally confused!
I have uploaded a copy of my spreadsheet here - https://dl.dropboxusercontent.com/u/45530070/PI Transaction Analysis 2013-08-10.xlsx
The challenge is that I have 6 other data tables linked to the calendar lookup table that I want to show in columns such that over all the different types of transactions I will get a grand total of how many transactions occurred per day.
I'm relatively new to PP and was hoping this would be an easy start to learning about this powerful tool. I have watched a lot of you tube and also bought Rob Collier's book and for some reason I'm totally stumped. Very frustrating when I know it's probably something really silly that I'm NOT doing right!
I'm ready to give up and do the analysis within excel.
I'm desperate! Please help me stay on the PowerPivot line!
Thanks in advance,
Suzi