Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic Product Ouput

I want to create a calculated column and a measure. So, that It can also change based on the filters for a similar data sample as shows below. Where the previous row in output column multiplies with the current row in the input column. 

Input columnOutput column 
22
36
530
6180
71260
810080
990720
Need Help
Show and Tell

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, is it possible if the values in the input column is repetitive and not in an order 

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      3 years ago

      Hi,

      Thank you very much for your message.

      In my opinion, if the sequence of the input column could be defined by another column in the same table, for instance, defined by index column or a date column, and then, input could be repetitive and not in order.

      I hope this helps.

      Thanks.