3 Replies Latest reply on Mar 15, 2018 12:52 PM by Deepak Rai


    Rose K

      I'm trying to write a calculated field for the output but I'm not sure how do I how to include date field to get 12 months data.


      My business logic is


      Sales(this is a numeric value)/12 months(date field)no of members in group.


      Sales: Represents the total sales

      Date field : Need to get data for only 12 months(most recent) - I have already created a rolling 12 month filter which is set to true but in this calculated field.

      Number of members in a group - We have 20 different groups so, we should get the count of members for one each group.


      ANy suggestions how this can be rephrased to a calculated field in Tableau.

      Thank You