Sales greater than previous year

[manu1512]

Hi all,

This is the interview questions.

There is table having companies sales yearwise.

Now I want to fetch company names which have more sales than previous year.

Can any one tell me that..how to approach this solution

Kind regards

Adarsh

[Vegar · Accepted solution]

Create a table with company as dimension and this expression

=If(Sum( {<year={$(=max(year))}>}sales) 

>

Sum( {<year={$(=max(year)-1)}>}sales), 'Greater than previous year')