Skip to Content
0
Former Member
Jan 31, 2009 at 12:51 AM

Sorting a variance column in Webi report

75 Views

I have the need to sort a report by a variance that I have calculated in the report.

For example, a report has inventory for end of prior month and current day. I am calculating the variance between the two columns. (how much inventory has changed by product)

I need to be able to sort this table descending so that I can see the big inventory movers first.

When I select the variance column, the sort options are disabled.

I have also tried to save my function as a variable and that does not seem to help.

I am using WEBI XI 3.1.

Any ideas?

Thanks in advance.