4 Replies Latest reply: Jun 25, 2016 8:06 PM by PAUL YEO RSS

    How to list sales increase and new customer from sales increase list ?

    PAUL YEO

      Hi All

       

      After you successfully help me on sales decline listing to break into 2 table.

       

      Now I have another list , which is sales increase listing table 1 Row 1 to 6 into Table 2

      when i try to follow the same approach , I manage to display 3 company only . i miss out 3 company. not sure why ?

       

      For new customer listing. Table 3., i try to filter Row 6 till 24 from Table 1 , i try to follow the same approach , but i still stuggle with it. Hope you can advise me.

          • Re: How to list sales increase and new customer from sales increase list ?
            PAUL YEO

            Hi Manish

             

            sales up list.png

             

            Above is the report i expected for sales increase list.

             

            Below is the report i expected for sales increase from new customer.

            new customer list.png

              • Re: How to list sales increase and new customer from sales increase list ?
                Manish Kachhia

                1st Table

                 

                 

                1st Expression

                if(

                Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                >=

                Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                ,

                Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                )

                 

                 

                 

                 

                2nd Expression

                If(Column(1),if(

                Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                <=

                Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate),

                Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate))

                )

                 

                 

                3rd Expression

                =If(Column(1),if(fabs(column(1))=0,1,column(2) / fabs(column(1))-1))

                 

                 

                4th Expression

                If(Not IsNull([YTD Variance]),1,0)

                 

                 

                 

                 

                 

                 

                2nd Table

                 

                 

                1st Expression

                If(

                  if(

                  Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                  >=

                  Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                  ,

                  Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                  )

                =0,

                 

                  if(

                  Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                  >=

                  Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                  ,

                  Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                  ))

                 

                 

                2nd Expression

                If(Column(1) = 0,if(

                Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

                <=

                Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate),

                Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate))

                )

                 

                 

                3rd Expression

                =if(fabs(column(1))=0,1,column(2) / fabs(column(1))-1)

                 

                 

                4th Expression

                If(Not IsNull([YTD Variance]),1,0)