I’m trying to create a new column with YTD figures in a table where we see EBITDA by market.
The logic we’re trying to find is to be able to tell Pigment that this column has to be the sum of the actual months and to group it all in a single column. That is to say, it would be something similar to a filtering option, just as we can filter by month to see the info for a specific month, so that we can choose to see only the YTD figures.
The idea is that it would be something dynamic and as we close new months that become current months Pigment would understand that the YTD info has to be updated.
Best answer by BenoitView original