9 Replies Latest reply: Jan 13, 2018 11:10 PM by Sunny Talwar RSS

    Straight Table Issue

    Rehan Saeed

      Attached please find the output in a straight table. I would like columns C and D to appear in one line and Column E should be the difference (-47285). Below is the expression I amusing for Column E.  available_qty and sum_orders are coming from 2 different data sets. I think there is a way to do it using Aggr . Also please note 2 different dates for both expressions

      Please help

       

      sum({<Date = {"$(vMax_Prod_Prod_Date)"}>}  available_qty)

      -

      sum({<Date = {"$(vMax_Prod_Order_Date)"}>}  sum_orders)