TOTALYTD function, but for some rows use another formula

[Anonymous]

Hi all - I have this problem I can't really figure out how to solve. I have a table with 22 lines and I want measures by month and YTD. By month (yellow, left side below) works fine - no problem. However, in the YTD (blue, right side where I use "totalytd" function) I actually don't want the YTD in line 21 & 22, but instead I want:

Line 22: should be equal to February (or whatever month is chosen in the filter) line 22: 87,244

Line 21: should be line 22 minus line 20: 87,244 - (-27,813) = 115,057

Any suggestions ? 🙂

Thanks

[v-eachen-msft]

Hi @Anonymous ,

You could use If formula to set a special condition for the last two values.

[amitchandak]

If Feb the last month or Feb is selected Totalytd will have data till Feb. All the values are the sum of Jan and Feb. Why you think the last two are wrong?