11 Replies Latest reply on Dec 24, 2019 4:52 PM by lei.chen.0

    Max function to sum one field

    Nat dbham

      Hi I have three different ways to cut the data for time FYP, Year or Period. The problem I'm facing is that I need to sum a measure for one period that would get me the count of people, while I need to select all periods to summarize the sales.

       

      I was trying to do a case that when 2020 is selected then sum count of personnel for period 2. Haven't been able to get it to work though. The two fields need to be in the same sheet, but if I have to select periods 1 and 2 to get the sum of sales, this throws my count of employees off. Does anyone have any recommendations of how to work around this?

       

      Thank you!