Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')