6 Replies Latest reply: Mar 1, 2013 10:29 AM by Suzan Liu RSS

    How do I show part of a list

      I have a list of account names (field name: account name).  How do I show only the account names where the status = new?

       

      Where is this done in the list options?

        • Re: How do I show part of a list
          Gysbert Wassenaar

          Add a listbox with Status to your sheet and select the value new in the listbox. That will filter the records on status new. Any table or listbox where you show account names will now show only the account names with status new.

           

          If you don't want that but you want to limit the list in a chart or table you can change your expression. Suppose you have account name as dimension and sum(Sales) as expression. If you change the expression to sum({<status={'new'}>} Sales) then you will only see the sales and thus account names with status new. Another option is to use a calculated dimension like =if(status='new',[account name]) and check the option Suppress When Value Is Null for the calculated dimension. In a listbox you would not choose the field, but the expression =if(status='new',[account name]) to show only the account names with status new.

          • Re: How do I show part of a list
            jagan mohan rao appala

            Hi,

             

            Please find attached file for solution, hope it helps you.

             

            Regards,

            Jagan.

            • Re: How do I show part of a list
              Kaushik Solanki

              Hi Suzan,

               

                   You can create a new field from script it self, if the Account Name and Status are coming from single table.

               

                   in this case you can use below expression.

               

                   if(wildmatch(Status,'New'),Account_Name) as New_Account_Name

               

                   Hope this will help.

               

              Regards,

              Kaushik Solanki

              • Re: How do I show part of a list

                Thanks everyone...  I created a listbox using expression, not field and put in 'if(wildmatch(Status,'New'),Account_Name)' which worked out super well.  It totally got rid of the need for buttons.