4 Replies Latest reply on Aug 25, 2018 10:11 AM by Srikanth Goli

    Value Based on Filter Selection

    Srikanth Goli

      Hi Everone,

       

      I am having some trouble trying to accomplish some basic calculation with Tableau so thought of leveraging the team's expertise.

       

      So I am trying to calculate avg based on the number of days selected by users in date filter. If you see the below image, user selected 6 days so I want a new column which divides the Furniture profit 74.2/6 = 12.3, 580/6, and so on. It should not consider whether there is data present in that aggregation level or not.

       

      My scenario is a bit more complicated but I drilled down to this simple scenario to get started since I cannot share confidential data outside.

       

      Tableau Desktop Version: 10.5 and workbook attached.

       

      Thank you in advance!

       

      Screen:

       

       

      Best,

      Srikanth