3 Replies Latest reply on Nov 26, 2018 7:41 AM by ShivaRam Chennapragada

    Format calculated field based off of parameter

    Alyssa Ashton

      I have a parameter that asks the user if they would like to view volumes by month or year.  This uses a calculated field called Date Selector: 

       

      CASE [Date Level Selector]

      WHEN 'Year' THEN [Service Date (Years)]

      WHEN 'Month' THEN [Service Date (Months)]

      WHEN 'Day' THEN [Service Date (Days)]

      END

       

      When I put Date Selector on the Columns shelf, how can I format it to view Month Year if the user chooses by Month, but only the year if the user chooses Year?  Right now if they choose year it will still show the month and year, Jan 2017, Jan 2018, etc.