• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

PowerPivot average

A

aggie81

Member
I am fairly new to Powerpivot and need help in getting the average units sold per week as rows based on the number of years displayed as columns. The example below shows the years and the units sold per week for the item 4" Sq Pots. I'm wanting to create a new column that would have the average.
Thanks,
Lee

Row Labels20102011201220132014
4" Sq Pot
326,7155,3776,3466,2077,309
336,1004,6235,9715,3555,590
343,8743,9353,6515,101
353,9202,7004,5854,282
366,1322,8485,9393,579
376,0236,4948,0707,472
388,8216,0657,3226,482
396,8235,7777,0867,559
 
An actual sample of the workbook would help, but one of the things to remember is that you will get better results if you had the average column in the data table.


.
 
You must log in or register to reply here.
Back
Top