current Month vs Previous Month

[Anonymous]

Hi,

I've attached an app. See Sheet 1

In table Current vs Previous, I want to show the Sum of Values for the current month in one column and the Sum of Value for previous Month in another column.

Showing only the month in column 2 and 3, I can show current month and its previous month, but when it comes to the Sum of values, I can't show the correct values.

Probably something wrong in my set analysis expression

Can you please help me?

This is what I want to achieve:

Thanks in advance.

Sílvia

[vinieme12 · Accepted solution]

Try

Dimension:

MonthYear

Expressions:

Current Month

Sum(Value)

PreviousMonth

Above(Sum(Value))

[Anil_Babu_Samineni]

I've used for Max MonthYear

Sum({<MonthYear = {"$(=Max(MonthYear))"}>}Value)

And Previous MonthYear i used this

Sum({<MonthYear = {"$(=Date(Max(MonthYear)-1,'MMM-YYYY'))"}>}Value)

Image looks like this, Is this you are expecting to see

[Anonymous]

Thanks Vineeth, it works

By the way, If I add a column that corresponds to the difference between the two values:

CurrentMonth - PreviousMonth: Sum(Value) - Above(Sum(Value))

If I create a line char with only this new calcultaion it works too.

This Above() function, can  it be used in all types of charts?

Regards,

Sílvia

[vinieme12]

Yes, you can but it can be tricky at times to make it work.

Here is another application of above() with Rangesum(), for accumulation of values

Accumulative Sums

[Anonymous]

Ok.

Another question:

I want that regardless the selection I made in MonthYear, it always shows all values.

I mean keep the table static, regardless all dimensions that are associated with dates.

I only need to add that to the set analysis ?

Like MonthYear=, Year=, Date=... Like this ?.

[vinieme12]

correct, should work