By using this website, you agree to our Terms of Use (click 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.
Online Members
