4 Replies Latest reply: Jun 25, 2016 8:06 PM by Yeo Poh sai

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

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.

my QVW

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

Hi Manish

Above is the report i expected for sales increase list.

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

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

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)

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

Hi Manish

Now working fine .

1) I make many mistake on 0 or 1 and > and <

2) Lucky you give me the expression , in case you only give me QVW , i don't think i am able to download as now my internet slow.

Great that now it every thing okay. are you work and live in Singapore ?

Paul