0 Replies Latest reply: Nov 13, 2016 1:38 PM by jeevayswaran a RSS

    Valuelist dimension work dynamically based on another dimension from data source

    jeevayswaran a

      Hi all,

       

      I have a dimension as Strategy and Date.

         

      StrategyMonth PNLYear PNL10/10/201610/11/201610/12/201610/13/201610/14/201610/17/201610/18/2016
      A28551898.33b------39138.01
      B28551898.33b-----1576481.41-
      C28551898.33b----3512355.50--
      D28551898.33b---1057485.72---
      E28551898.33b--703510.02----
      F28551898.33b-21295.58-----
      G28551898.33b2784667.06------

       

      the above table is shows date wise PNL. it is a pivot table. the dates are latest one month dates only.

       

      here, i used in Month PNL column is a valuelist($(vMonthPNL)) (i.e vMonthPNL=sum(PNL)) filed to get sum of values of displaying date or last month only. but it is showing all month and strategy's PNL. how i achieve this?? as well as Year PNL also i need year wise PNL.