1 Reply Latest reply on Feb 12, 2019 12:31 AM by Abdul Munaf

    Table calculation from average per row

    daniel.andell

      I have a table with data per month where the user can select the period they would like to look at. I would like to color each row and month depending on the current average. If the monthly sales is above average then I choose blue if its below I choose orange.

       

      In the table calculation tool I can only calculate from previous, next, first and last.