Forum Discussion
Orange2045
Helper I
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,2...
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
danextian
Super User
Super UserHi 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:
Orange2045Helper I
Helper Isorry 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