Is it possible to group 2 rows into one ?
e.g.
Revenue
-Unit
Revenue
-Parts
to
Revenue
-Unit
-Parts
The Revenue is a compute field with a expression if(account_main_short_title='UNIT' or account_main_short_title='PARTS','Revenue','')
I've done already playing with datasource and ask Mr. Google but still i cant fix my problem still trying to fix this for almost 5hrs.
Thanks in advance.
This question is closed, i already answer my own question by playing the sort in datawindow, i just added the category which is my compute field.
Thanks.