5 Replies Latest reply on Jan 23, 2019 5:40 AM by pavan hm

# taking sum of calculated averages and subtracting value from different sheet

Hi everyone,

Attached a sample excel sheet and corresponding tableau workbook.

for excel,
sheet 1 contains the sample dataset. - out of which i am preparing tableau sheet 1 and 2.
Exact final outcome i want - that's described in excel sheet 2 (things that are blue marked what I calculated in tableau and the row highlighted in green- is something that I desire.)

Now in my tableau dashboard- i am unable to carry out these two operations.
1) taking sum of two values which are obtained using average (cell c17 in excel sheet 2).
Since C14 and C15 are average values (tableau wb sheet 2), if i take column total- it gives me average, not sum.

2) Once this value is calculated, subtract it from a number obtained from a different worksheet (refer C18 in sheet2, excel), however source table remains same.

Any help will be highly appreciated.

Regards-

Sourav

• ###### 2. Re: taking sum of calculated averages and subtracting value from different sheet

hi Pavan,

the numbers are not matching with excel sheet 2.

Also can you share your workbook.

-Sourav

• ###### 3. Re: taking sum of calculated averages and subtracting value from different sheet Pls find the updated workbook.

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 4. Re: taking sum of calculated averages and subtracting value from different sheet

Hi Pavan,

That's correct.

Can you share the formula and logic how you have done it, thanks!

• ###### 5. Re: taking sum of calculated averages and subtracting value from different sheet

Hi saurav,

I have attached the workbook .you can see all logics and formulas .

Please mark it correct if it helped.