1 Reply Latest reply on Jun 22, 2016 8:44 AM by Steve Taylor

    calculate based on filter

    Joann Pendleton

      Is there a way to count the number of months selected by a filter.  I need to multiply a monthly budget number by the number of months the user selects in a sliding filter.

        • 1. Re: calculate based on filter
          Steve Taylor

          Hi Joann,

           

          Can you try this calculation:

           

          Screen Shot 2016-06-22 at 16.42.35.png

           

          on the month you're using in your filter?

           

          If that doesn't work could you please mock up an example of what you're trying to do using anonymised data or the superstore sample data provided with tableau and post a twbx file to this thread?

           

          Many thanks

           

          Steve