3 Replies Latest reply on Apr 4, 2016 7:49 AM by Mahfooj Khan

# Weighted Average (row-based)

Is it possible to create a weighted average for 2 or more columns while the other columns are in Sum?

I need to get the Sum and Weighted Average per Region (Total row):

Order Volume --> Sum

Interval 1 and Interval 2 =

(   ( for Vendor ABC01:  Order Volume * Interval 1 ) + ( for Vendor DEF05:  Order Volume * Interval 1 ) + ( for Vendor GHI04:  Order Volume * Interval 1 )      )  /  ( SUM(Order Volume))

eg.

(  (9 * 33) + (10 * 15) + (9*12)   )  / 28   = 19.82   (Weighted Average for Interval 1)

The output should look like this:

• ###### 1. Re: Weighted Average (row-based)

Create three calculated fields

Create a dummy string calc field.

Drag all the calc fields in sheet1(total) as per below screenshot

Put your base data in second sheet(base data)

Create a dashboard drag base data first as tiled. Then you drag total sheet as flaoting. Hide the titles from both the sheets.

Or

Hide the headers from total sheet

I hope this is your desired output

Mahfooj

1 of 1 people found this helpful
• ###### 2. Re: Weighted Average (row-based)

Thanks Mahfooj for taking the time to answer my question.  I think you're answer is correct however if I have multiple regions or other dimensions to use  aside from Region which is more than 50 items I guess it will be hard time adding individually the data values and the weighted average or Total values