Solved

Full year as calculated item

Forum|Forum|8 months ago
March 16, 2025
2 replies
84 views

+4

Bas
Master Author

Hi everybody,

I have a grid with two time-dimensioned calculated items. One is YTD and one is YTG where they cumulate using the selected month:

These work fine, but I also want to create a calculated item that shows the sum of both YTD and YTG (i.e.: full year). I couldn't get it to work via calculated items in the same grid, so as a workaround I made a second grid that shows the full year P&L. Although that workaround is okay-ish, I'm sure there must be some (better) way to get Month | YTD | YTG | FY in the same grid?

Thanks, Bas

Best answer by Min Li

@Bas

I added another Calculated Item for FY, and under the item, just put the end month of the actual year and do cumulate.

The bottom table is how my entire table looks like.