I can create nice lookint "excel" tables via the Table Builder. I managed also to add linked tables etc.
What doesn't seem to work is:
- adding formula's (e.g. = colunm A + column B)
- adding totals works a bit strange (if I add column total of one column it does them all..)
if you build a normal table (non-Excel) you adding formula's like above are no problem, but if it isn't a excel table you cannot build e.g. pivot tables on it. Is it possible to build an excel table automatically after getting the live data.
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment It's actually possible to add formulas where you add the results of other columns in the Jet Table Builder. In the section right below the fields there is a button with the text "+ Add Formula". After you add the formula you will see the text box on the right with the formula. You use the @ character to start a reference to other columns in the table and then you will get a lookup popup to select the column you want. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts This is exactly what i was searching for. Thanks!
Please sign in to leave a comment.