Forum Discussion
Helper ICompare cumulative years
Dear all,
i need to creat 2 columes (in a matrix) to compare
- cumulated data from 2020-2022 with
- cumulated data from 2022 -2023
i first creat the 1st colume with filters on year to 2020,2021 and 2022. but i dont know how to creat a mesure for the 2nd colonne?probably this is not the best way to do it.
Could you please help me?
Thank you,
Annie
sorry if my question is not clear.
I creat a balance sheet of end of 2022 (column "Amount"). you can see that by filter i choosed data of year 2020+2021+2022.
I need to add another column "Amount N+1", which will included data of 2020+2021+2022+2023.
how i can do that? thank you
2 Replies
- danextian
Super User
Hi Orange2045 ,
Please provide a sample data (not an image) that completely covers your use case and the expected result using that sample data. Here's how to do it:
Orange2045sorry if my question is not clear.
I creat a balance sheet of end of 2022 (column "Amount"). you can see that by filter i choosed data of year 2020+2021+2022.
I need to add another column "Amount N+1", which will included data of 2020+2021+2022+2023.
how i can do that? thank you
