0 Replies Latest reply on Oct 25, 2018 9:18 AM by sahil k

    Calculation for Sum of one of measure for Current Quarter and Previous

    sahil k

      Due to sensitive information, i can not share the file. But what I am trying to do is to get the sum of one of the measure by the Current Quarter. Apart from this I want the sum of one of the measure by the Last Quarter (which can be last year too or current based on current time frame). For current year I created calculated field using max however when i threw quarter in the filter column using max it shows 4 because its aggregating the count. I even tried using year and quarter as filter and use the formula there under condition ,but, if i use max it says it has to be a boolean. Kind of running out of ways to show.

       

      Below is how i want information to display. Only one figure which is the aggregate of the measure for the current quarter and aggregate of the measure for the previous quarter than today. By the way, I have the quarter field in Tableau already.

       

      Current Quarter Information (Sum of one of the measure)

      109

       

      Previous Quarter Information (Sum of one of the measure)

      50

       

       

      Any pointers is appreciated!!!