Placement of rows in QV report

[#1]

Hi guys,

I am creating a report where certain rows supposed to appear in a certain sequence but QV always sorts them.

For example...

my report looks like

COST

          100

Expense

          500

Income

          1000

But I want it look like

Income

     1000

Cost

     100

Expense

     500

Is it possible to do in QV?

Regards,

Saurabh

[swuehl · Accepted solution]

You can assign your dimension values a dual value using the dual() function, then sort your dimension numeric on sort order tab. Or use an expression to sort:

=match(DIMENSIONFIELD,'Income','Cost','Expense')