4 Replies Latest reply: Apr 14, 2017 7:21 AM by Robin Hausdörfer RSS

    Set Analysis issue

    Sibin Jacob.C C

      Hi All,

       

      I need a help on the below set analysis.

      I have two columns, one is SALES_DATE and another PURCHASE_DATE.

      User will select the PURCHASE_DATE in the dashboard

      I need to show the sales in the table of which date is selected by the user.

       

      AGGR(only({<SALES_DATE=P(PURCHASE_DATE)>} SALES_DATE), SALES_DATE)

       

      I am using the above formula for the dimension, which is working fine if I have sales date for the Purchase date user selected

      For Example : User selected 17/01/2017 in the Purchase date list box, but I don’t have sales in that date so I need to show the near previous sales data in the table, that is 15/01/2017


      Thanks,

      Sibin Jacob. C