3 Replies Latest reply on Feb 4, 2016 12:22 PM by Melissa Baxter

    Calculated Field for Last Digit

    Melissa Baxter

      Hi Everyone!

       

      I was recently given an assignment. Within this assignment, there is a dimension which indicates what type of product that customer issues (ex: if it ends in 1, it means clothing, 2 means vehicle, etc.). My goal is to create a parameter/filter which only shows each type of product: Essentially I am looking to create a calculated field along the line of "If last digit of this field =1, Then "Clothing", etc. This way, if we wanted to only look at all the clothing customers we would see all in one graph.

       

      I have tried searching the community pages as well as the internet, but I have not been able to find any answers yet. I greatly appreciate any help in advance! Thanks!