1 Reply Latest reply on Dec 3, 2018 11:18 PM by Ritesh Bisht

    action filters for the dimension which are not in the database

    sunil sudendran

      Team

       

      Please help me setting action filters for the column ratio and calculation 2 and calculation 3 .
      as we dont have dimension for those.

        • 1. Re: action filters for the dimension which are not in the database
          Ritesh Bisht

          Hi Sunil,

           

          I don't think if there is any direct way but you can check the below post

           

          I don't know of any way to use an Action Filter within a calculated field. One way to get your desired results is to duplicate your data source and then edit the relationships between the primary and secondary to remove the linking fields that would add too much detail (such as provider in your case). Then you can have a worksheet that shows the chosen provider and the totals. I've set an example up in the attached, using Sub-Category in place of Provider.

           

          Cheers,

           

          Jonathan

           

          Use Action in Calculated Field

           

          There is a workaround there

           

          Regards,

          Ritesh

          Please mark the answer if helpful so that it can help others as well