Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe try this one:
sum(Value)-Before(sum(Value))
Athough it will work only if Year will be in the columns headers
You could try this:
column(1) - column(2)
Maybe try this one:
sum(Value)-Before(sum(Value))
Athough it will work only if Year will be in the columns headers
Thanks!
It works