Comparison of values

[vkozlov]

Good day, team!

Help me somebody

What method can be used to compare values obtained by the example in Table:

dimensions:  Year, CompanyName

expression- sum of sales

Need to get the difference of sales amounts for each related period (example: difference between 2008 and 2007; 2009 and 2008 etc.)

There is an idea to build a table with several expressions:

=Sum({<Year={2007}>}LinesalesAmount)

=Sum({<Year={2008}>}LinesalesAmount)

=Sum({<Year={2008}>}LinesalesAmount) - Sum({<Year={2008}>}LinesalesAmount) // difference

etc.

But it seems that the decision irrational because with a large variety of Year - to be a lot of routine work

[oknotsen]

You could try this:

column(1) - column(2)

[#3 · Accepted solution]

Maybe try this one:

sum(Value)-Before(sum(Value))

Athough it will work only if Year will be in the columns headers

[vkozlov]

Thanks!

It works