I am using List and Label 22 integrated into a german accounting software Proffix. What I have done so far is create a crosstable with column headers as expense accounts and the rows being various lot numbers for products that we ship. Each row therefore prints out various expenses for a certain lot. Everything goes well up to this point. Now at the very end of my table I want the column totals to dispaly, i.e Expense account totals. Here is where I have tried everything I can think of and for the life of me cannot find a solution.
To be more specific, each cell in a certain row has the value @SaldoKonto which as far I understand represents the value of that expense for a specifc lot. I have tried using crosstab functions to no avail as they seem to not work or I just am not sure where I can call them, as wherever I use them just gives an error.
My question results from both the fact that I am English and am trying to set this up in software in German with no option to change to English, as well as the fact that I am completely new to List and Label as well as SQL.
Thanks for the Help!
PS. If it is unclear I can attach some pictures in a following post to clarify.