reset
3 TopicsCan i get reset on my submission for certification?
Hey community, thanks for the read. Essentially..... i tought the only sql videos available were the ones towards july. seems its not. and now i cant change to the ones i actually watched. this would get me out of date for the certification chances. and i would for sure like to apply. let me know if its a possibility and how. or if its on FabricMS side. thanks and have a good day701Views0likes1CommentCumulative reset after reaching sales target
Hello everyone, I have sales data set containing sales amount of every stores in 3 different regions. Each region has their own sales target (column Target Sales), I want to calculate a cumulative sum of sales amount such that it is resetted once the target is reached or almost reached. I tried using grouping method but do not get 100% desired result. For example, for the South region, the 'Reset cumulative' works perfectly until group 3. Group 1 includes 0.29 + 8.57 + +1KViews0likes4Comments