Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all -
I have a table with these fields: Debit Month Number, Year, Accounts and Base Accounts. Below is the output I am trying to derive for "Base Accounts". It should repeat the values from "Accounts" where "Debit Month Number" is equal to 0, for each respective year.
"Accounts" is this measure: count(distinct ACCOUNT_ID).
Is there an easy way to do that in the front end without having to change any backend scripting?
Thanks in advance.
Debit Month Number | Year | Accounts | Base Accounts |
0 | 2017 | 100 | 100 |
0 | 2018 | 150 | 150 |
0 | 2019 | 125 | 125 |
1 | 2017 | 75 | 100 |
1 | 2018 | 125 | 150 |
1 | 2019 | 100 | 125 |
2 | 2017 | 60 | 100 |
2 | 2018 | 115 | 150 |
2 | 2019 | 80 | 125 |
3 | 2017 | 55 | 100 |
3 | 2018 | 105 | 150 |
3 | 2019 | 70 | 125 |