I create a table to join some information and create a Full P&L per month. I want to use the formula YearToDate, it it possible? How can I do that?
Page 1 / 1
Hi Carolina,
A table is just a display, you cannot add a formula specifically in the table.
If you modify a formula in a table, it will modify the metric.
For year to date, I’d suggest that you create a dimension called “Period Outlook” with two items: Monthly & YTD
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/eaf10ed4-6e33-427f-8075-c1c31cd19296.png)
Then you can add this dimension to your metrics and use YEARTODATE() like this:
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/06b6f623-897f-4b0a-a623-f0cdd278ae93.png)
Be careful when adding a dimension, you will loose data (not formula). You can try in a new metric.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.