Hi,
I have created a Tickets table and a Dates table in powerpivot. When I add my "month" to the pivot table as a row label, there is an empty row at the end. I have quadrouple checked that I did not leave any blank rows in the dates table. Why would this be? I think it is preventing my Tickets from summing by month (when I add the tickets to the pivot table, all of the "months" disappear).
Thanks!
Jamie
I have created a Tickets table and a Dates table in powerpivot. When I add my "month" to the pivot table as a row label, there is an empty row at the end. I have quadrouple checked that I did not leave any blank rows in the dates table. Why would this be? I think it is preventing my Tickets from summing by month (when I add the tickets to the pivot table, all of the "months" disappear).
Thanks!
Jamie