Forum Discussion
Solved
Totals Not Correct on Sum
Hey guys, I'm sure this is an easy one but why are my totals not reflecting my filters on the page? I am not using measures but rather existing numbers in the table and the sum function.
m4kaveli , please share the measure formula, It may be because of row context
https://www.youtube.com/watch?v=ufHOOLdi_jk
amitchandak
Super User
Super Userm4kaveli , please share the measure formula, It may be because of row context
https://www.youtube.com/watch?v=ufHOOLdi_jk
Thanks amitchandak . Thats what i'm getting thrown off by here because I don't have a measure at all. I'm simply using the raw data and the sm function for the value. Here is the correct list with totals as you could see it adds up. However, as soon as I filter by the cdlinestatscode of CUW, the total doesn't change and remains 8,770.08. So I guess i'm asking why the total doesn't reflect my filter being set.
Before filter showing Total:
After filter showing same total not reflective of my filter:
