1 Reply Latest reply on Mar 9, 2018 12:41 PM by arvindgarg

    Calculate Average for only totals

    geoff southmayd

      In one of my datasets I have headcount data stored for each month, where the value in a given month is the total of all headcount in that period. I'd like to write a calculation that would show the total month's headcount when month is within the view but whenever I show QTD or YTD it calculates the average of the underlying time periods. For example, If I had 10 heads in January, 20 in Feb and 30 in March I would want those values to show up when I view by month but if I show Q1 it would show the average heads for the quarter which would be 20.