Hello,
Please I want to design a report on SSRS.
The columns are; Item number Doc type Transaction qty
Hace1 POP 5
Hace1 SLS -5
But I want the qty for SLS to show in another column like this;
Item number Doc type Transaction qty Qty Sold
Hace1 POP 5
Hace1 SLS -5
Please how can I create such column when I have just one field containing the transaction qty.
Please I need your help.
Thank you
*This post is locked for comments