Hi Everyone,
How can I use before function when there are 2 or more columns used in a pivot table. For example:
Table:
| Actual |
Budget |
| 2021 |
2022 |
2021 |
2022 |
| 34 |
56 |
45 |
77 |
| ... |
... |
... |
... |
I want to add a column that will compare relevant actual and budget periods
| Actual |
Budget |
| 2021 |
2022 |
2021 |
2022 |
| Value |
Before |
Value |
Before |
Value |
Before |
Value |
Before |
| 34 |
- |
56 |
- |
45 |
34 |
77 |
56 |
| ... |
... |
... |
... |
... |
... |
... |
... |
Value and before being the two measures.
