1 Reply Latest reply on May 29, 2014 11:36 AM by Don Barnetson

    I need to extract and rank a dimension

    Victoria Ruiz-Tagle

      Hello,

       

      I have a dimension with multiple accounts, and I need to group them in different item, anyone know how to do it, but I need to show this information in the same dimension, like +year+month+day , eg

       

      I have this in the dimension account (basic account)

       

      1.dog

      2.cat

      3.Trucks

      4.ETC

       

      and I want to create groups within the dimension and to display like this:

       

      accounts

            result

                truck

                auto

                motorbike

            shopping

                 money

                 etc.

       

      I try this with sets and groups but this is not I need, I hope it has been clear, I think I can do this with the "IF" command but I have many accounts on the dimension and this would be an eternal work.

       

      My regards