Forum Discussion
Post PatronP&L problem with "Sort by"
Hello AndrejZitnay,
I understood the issue now. You need to create a conditional column(TypeOrder) for Type where
ADMINISTRATION COSTS =1,
DIRECT COSTS = 2,
INCOME = 3
Create one more conditional column for Category similary and indicate the order of each value.
Later you can do sorting based on TypeOrder and Type . I hope it works for sure. Let me know again.Regards
Ajay Emmadi
Post PatronHello ajayemmadi1
It is. Index is whole Number.
Before Index was trying to duplicate my Nominal Codes and change that to number for sort option.
None of these get me right order ofr Type or Category. I always have only corect Order for NC Full String within Category.
Thanks for trying to help me.
Helper IHello AndrejZitnay,
I understood the issue now. You need to create a conditional column(TypeOrder) for Type where
ADMINISTRATION COSTS =1,
DIRECT COSTS = 2,
INCOME = 3
Create one more conditional column for Category similary and indicate the order of each value.
Later you can do sorting based on TypeOrder and Type . I hope it works for sure. Let me know again.
Regards
Ajay Emmadi
- AndrejZitnay