3 Replies Latest reply on Jan 2, 2019 5:40 PM by Chris McClellan

# Sum for columns only and average for lines

Hi community,

i have an issue when trying to generate workloads and agregating them into Year or Quarters.

The workload that i want to show is the sum for each person over multiple projects, when showing the monthly view everything is fine, but when i go to quarter or year, it calculates the sum of the load which is wrong, it should only keep the average (ex : load for Mister A in jan = 1, feb = 1, march= 1 => quarter = 1 not 3)

Now, when instead of calculating sum, i use average, the average is not only done on rows (rows being quarters) but also on columns (project)

I want to keep the sum of all projects over one person, but have the average over time....

a few images to illustrate :

1/ monthly view : OK

2/ quarter (or year) view nok because it makes the sum :

3/ if i use the average function instead of sum : it applies the average calculation vertically and horizontally (i want horizontal only)

Thomas

• ###### 1. Re: Sum for columns only and average for lines

Do you have some dummy data / workbook that you can attach to help others help you ?

1 of 1 people found this helpful
• ###### 2. Re: Sum for columns only and average for lines

Several ways you can go.
1) Use LOD in order to exclude the fields that you want not to be part of the calculation.
2) Create several sheets and join them on a Dashboard.

If you can send a sample data as stated above we can look into it.

Happy year!

• ###### 3. Re: Sum for columns only and average for lines

Thomas Pajor wrote:

3/ if i use the average function instead of sum : it applies the average calculation vertically and horizontally (i want horizontal only)

You can control the "direction" of the calculation by clicking on the field where you have done the table calculation (ie MOY(Load) and change the Compute Using option

1 of 1 people found this helpful