4 Replies Latest reply on Aug 16, 2018 10:52 AM by Claudia Martinez

# Sum of average (part 2)

Hello I have an other question in this case because when i put a filter the result is different (only 1 or 2 numbers)

Check this exemple when applied some filters

Look the sum IBM (Simple)=11+20+31=62

Total RFS SLA Repor (Simple)t= 63 ¿?

Regards

• ###### 1. Re: Sum of average (part 2)

Hi Claudia- I'm not sure if I understood your question correctly, in the grand totals, Tableau is Averaging the averages so you see the number. Are you looking for something like this?

Re-arrange pills in rows, from analytics pane - add totals and grand totals. Change totals using "SUM" from "Analysis" tab.

Let me know if I got it wrong, elaborate a little please.

Thanks,

Shiva.

• ###### 2. Re: Sum of average (part 2)

Hi ShivaRam

I looking that the result will be exactly when include some filter

If you see my screen, if you sum the first table IBM (simple) 10+´20+28=58 and is exactly that the second table IBM(simple) 58

When i put a filter the results aren´t exact

look

thanks for you Support

• ###### 3. Re: Sum of average (part 2)

Hi Claudia,

This is happening because Tableau is rounding your measure values to the upper bound/ ceiling.

Same filter as you have shown above:

So if you edit the Measure Names formatting it will show you the decimal places and you can tally it accordingly.

Hope this helps.

Soham