Sales greater than previous year

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sales greater than previous year

Vegar — Sat, 14 Sep 2019 13:18:41 GMT

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')