-
Posts
-
When I insert a difference column on a custom anaylsis report, how do I know which columns it computes the difference of if there are more than two? Is there a way to control which columns are subtracted from each other?
Also, how do I get rid of unwanted columns on a custom analysis report? If a column is sortable, I can simply select it and then delete it. However, I can’t select amount and difference columns.
Please advise. Thank you,
-Tamara
When you create a difference column in the custom analysis, the difference column is added after the last column and the difference column is calculated on the last two columns prior to the addition of this difference column.
You can move any column by holding the control (Ctrl) key and then use your arrow keys to position the column where you like.
Currently, the calculation of a difference column is based on the two columns before it.
To remove unwanted columns, click on a cell or field within that column and hold the control key and press the delete key at the same time.
Regards,
Martin
- You must be logged in to reply to this topic.
