How to filter only sales change are more then 0% ?

[#1]

Hi All

I have a table which display CY and LY sales and i also have a 3 col which display the sales change %.

Now i like to make my table only list those sales up customer.

Hope some one can advise how to achieve this ?

[phaneendra_kunc]

So you don't want to display any -ve % values?

[#3]

So that sales person can take action on those sales increase customer. So that sales can further increase. And still want to view the % up.

Sent from Samsung Mobile

[iktrayanov]

Use % increase as your first expression and use dimension limits by first expression.

[phaneendra_kunc · Accepted solution]

See attached.

[#6]

Hi sir

Thank you very much. Can you pls give me some example ?

Sent from Samsung Mobile

[#7]

Hi sir

Yes this is what i need. But i am not able to figure out how you do it. can you share with me ?

Paul

[#8]

Hi All

Phaneendra Provide me a soluition , which is very good. but i am not sure how he filter only display +Ve % value , can some one tell me ?

[iktrayanov]

I think he changed your expressions to only calculate when sales for the current period are more than the sales for the previous period. Take a look at your expressions. Hope that helps.

[#10]

hI iVAN

He very smart.