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