3 Replies Latest reply: Sep 8, 2017 5:07 AM by beck bakytbek RSS

    prevous() , above () or peek

    beck bakytbek

      Hi Folks

       

      i got a situation,

       

      i have the pivottable (see attached screenshot),

      2 Dimension and one Expression: Customer, Year and Sum(Sales). My exprected output is: if i have in Year: 2015 for Customer 1 the Null in Sales, i want to take over the previuos value: 100.

       

      my question, wthat is the best way to solve this issue, previous, above or peek?

       

      Thanks a lot

      Beck