— The Forums are now read-only —
— All new activity now takes place here: —
I have a simple T12 I built and I want to show my Account, Sub Account and Account Description in three separate columns but I cannot figure it out. I would think it should be pretty straight forward. Below is all I have been able to get. Is there a way simple way to use column sets and add have three description columns?
| April 30, 2018 | May 31, 2018 | June 30, 2018 | |
| 300101-Room Rev - General | 176,704.92 | 436,238.09 | 548,363.27 |
| 300102-Room Rev - General TE | 9,228.35 | 17,753.51 | 58,111.39 |
| 300103-Room Rev - General OT Only | 31,709.02 | 45,840.98 | 51,230.63 |
| 308501-Other - Baggage Handling | 0.00 | 385.19 | 1,477.27 |
I'm not sure how to get both Account and Subaccount.
If you do this formula in a calculated column in the Column Set:
=@AccountCode+' - '+@AccountDescr
It yields two different results depending on whether you set Expand to Account or Sub on the Row Set:
If you set Expand to Account then the formula only prints the Account information:
If you set Expand to Sub then the formula only prints the Subaccount information:
But I don't know how to print both. Not sure, but you might be able to do this in Velixo Reports.
By using this website, you agree to our Terms of Use (click here)
