Hi!
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.
Page 1 / 1
Hi
You can calculate it by Yeartodate function.
Hi,
Many thanks for your reply!
I’m trying to do it by Yeartodate function but I have the error that I attach in the screenshot. Do you know how can I solve it?
Hi,
It seems to me that your formula should probably look like this:
Yeartodate(metric[filter: Version.”Actuals”])
Let me know if this helps.
Best,
Benoit
Reply
Sign up
Already have an account? Login
Log into the Pigment Community
Single Sign-On Need help?
Login with Saml2 Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.