1 Reply Latest reply on Aug 10, 2016 4:53 AM by Luciano Vasconcelos

    Sum of values for max(month)

    Dhruv Khandelwal

      Hey

      I am new to tableau so this might seem like a very easy question.

      I have a dataset that looks like this:

       

      Month     Revenue    

      1                    5

      1                    4    

      1                    3

      1                    2

      2                    4

      2                    4

      2                    4

      2                    6

      3                    8

      3                    8

      3                    9

       

      and there is a month no. up to filter that is input by the user. I need to get the sum of revenue for the last month that the user inputs.

       

      Eg. If in the above data the user picks 2, i want to calculate 4+4+4+6

      similary if the user picks 3 then 6+8+8+9

       

      Thanks in advance for the help.