|
I have a report which I need to Group by type but the rows under the group should be sorted based on specific field code. from the below eg. the code field needs to be sorted in NSL,CON,RWR,TAN order within the grouping.
TYPE DATE NAME CODE
Cem
cem NSL
cem CON
cem RWR
Fun
Fun NSL
Fun CON
Fun RWR
Fun TAN
Class
Class NSL
Class RWR
|
|
Create a formula that looks something like this:
Switch(
{MyTable.Code} = 'NSL', 1,
{MyTable.Code} = 'CON', 2,
{MyTable.Code} = 'RWR', 3,
{MyTable.Code} = 'TAN', 4
true, 5
)
Go to the Sort Expert and use this formula as a sort under your group.
-Dell
|
IP Logged
