Fill the metric which is duplicated with 0 or average so that the aggregate makes sense

[pachopra]

I have a report where one of the metric shows multiple times because its at a higher grain in another dataset which was joined to the original dataset at a product level. How can I fill the duplicated rows with 0 or an average of the number in those rows impacted so that my metric total makes sense. I need two kinds of output if possible. Thank you for the assistance

[gautiergodard]

Hey @pachopra 

Here is one way to get to your second output. Is output 1 meant to be input and output 2 meant to be output?

Can you please clarify?

[pachopra]

Hello - I will try your solution but to clarity no output 1 and output 2 are just two ways to get to the desired goal of getting the aggregate total correctly. Is there a way to get output 1 from the original input

[gautiergodard]

@pachopra got it, sorry i missed the rows all the way at the top.

here is the solution for both.

if you want to add a total row, you can use a summarize tool and sum the entire column.

hope this helps!

[binu_acs]

@pachopra one way of doing this