Skip to main content

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:

 

YTD
YTG

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

​@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.

 

 

​@Min Li Bright Point  A great answer! Dr. Li YYDS

Reply


Ask your question here!

Terms & ConditionsCookie settings