Forum Discussion
hemantkg
9 years agoFrequent Visitor
Running Total - Incorrect Results
I have searched the forum for possible solution to below scenario, could not find any leads. Following is the data snapshot: Date Sales Person Geography Sales 1/1/2017 A X 10 1/1/...
- 9 years agoHi hemantkg,
It's 320 cause you are using calculated column. Behind the scenes, it iterates row by row and cumulatives sum values, but there are 8 rows in April when it should be 9 rows as another months. My recommendation is using calculated measure.
hemantkg
9 years agoFrequent Visitor
Thanks Victor for quick reply. Tried it, it doesnt even work as expected: