Can someone please show me how I can get running total after applying this formula? ZN(LOOKUP(SUM([Measures]),0))
I used that formula because I wanted to fill in all empty cells with zero. But then, I can't get Running Total under quick calculation anymore.
Can someone help please.
You just need to build it RUNNING_SUM(ZN(LOOKUP(SUM([Measures]),0))), however ZN(SUM([Measures])) should return the same thing as you are not offsetting your lookup, you would be able to do a quick calc on this formula.