highlet highest and lowest values based on selection

[#1]

Hi

I have scenario

I have data like below

Date             Location      Sales        Growth

2016-01-01      Delhi          10000       -10000

2016-02-01      Delhi          15000         50%

2016-03-01      Delhi          20000          33% 

2016-04-01      Delhi          10000          -50%

2016-05-01      Delhi          30000           200%

2016-06-01      Delhi          45000           50%

2016-07-01      Delhi          60000           33%

2016-08-01      Delhi          50000            -20%

2016-09-01      Delhi          100000           100%

Growth  is multibox

If i select filter as 5 Means last 5 months

i want to highlet highest value and lowest value

Growth  =5 then

Date             Location      Sales        Growth

2016-04-01      Delhi          10000          -50%

2016-05-01      Delhi          30000           200%

2016-06-01      Delhi          45000           50%

2016-07-01      Delhi          60000           33%

2016-08-01      Delhi          50000            -20%

2016-09-01      Delhi          100000           100%

if Growth  =3 then

2016-07-01      Delhi          60000           33%

2016-08-01      Delhi          50000           -20%

2016-09-01      Delhi          100000          100%

Please do the needful

Thiru

[sunny_talwar]

Growth is percentage, How can you select 5 or 3?

[#3]

Hi Sunny,

That is months from Now

for example 5 means from now to last 5 months

3 means

from now last 3 months

Thiru

[sunny_talwar]

So is there another field that you have? or is that you wish to create in the script?

[#5]

Hi

Date             Location      Sales        Growth                Month_No

2016-01-01      Delhi          10000       -10000                 9

2016-02-01      Delhi          15000         50%          8

2016-03-01      Delhi          20000          33%          7

2016-04-01      Delhi          10000          -50%        6

2016-05-01      Delhi          30000           200%      5

2016-06-01      Delhi          45000           50%        4

2016-07-01      Delhi          60000           33%       3

2016-08-01      Delhi          50000            -20%     2

2016-09-01      Delhi          100000           100%    1

some thing like this

Thiru

[#6]

Hi Sunny

Month_No is Growth filter here

Thiru

[antoniotiman]

Hi,

see Attachment.

Regards,

Antonio

[sunny_talwar]

Check the attacted

[#9]

Hi Antonio,

It is slimier to my requirement but i dont want to create month i want to use date only,but when i replaced month with date1 it is not working.

if possible can you change the code with date it self .

Thanks in advance

Thiru

[#10]

Hi Sunny,

I am not expecting filter records,i need to show all records

and

i want ti high let with some back ground color  based on selected months

for exapmle

5 months

Date            Location      Sales        Growth                Month_No

2016-01-01      Delhi          10000      -10000                9

2016-02-01      Delhi          15000        50%          8

2016-03-01      Delhi          20000          33%          7

2016-04-01      Delhi          10000          -50%        6

2016-05-01      Delhi          30000          200%     5

2016-06-01      Delhi          45000          50%        4

2016-07-01      Delhi          60000          33%      3

2016-08-01      Delhi          50000            -20%     2

2016-09-01      Delhi          100000          100%    1

i highleted 200 and -20(max and min)

3 months

Date            Location      Sales        Growth                Month_No

2016-01-01      Delhi          10000      -10000                9

2016-02-01      Delhi          15000        50%          8

2016-03-01      Delhi          20000          33%          7

2016-04-01      Delhi          10000          -50%        6

2016-05-01      Delhi          30000          200%     5

2016-06-01      Delhi          45000          50%        4

2016-07-01      Delhi          60000          33%      3

2016-08-01      Delhi          50000          -20%     2

2016-09-01      Delhi          100000          100%    1

i highleted 100 and -20(max and min)

Thanks

Thiru