Month on Month % calculation

[nareshthavidishetty]

Hi,

We need to do a month on month % calculation.

Logic: 2017 sales-2018 sales/2018sales

I need to get this in front end expression.

Please let me know how to get this.

Attached is the sample datasource.

Thanks..

[Anonymous]

Hi,

Perhaps the following will give a good start:Current Years Current Month Vs Last Year Same Month Data

[nareshthavidishetty]

Please share the logic.I have tried but its not working.

Thanks..

[niclaz79]

(Sum({<Year = {$(=Max(Year)-1)}>}sales)-Sum(sales) ) / Sum(sales)

Works, considering you have a selected year (2018 for instance) and month.

[nareshthavidishetty]

Hi,

Please find below .

I need to show some thing like this.

Thanks..

[niclaz79]

Hi,

Using your example data and

Dimension : Month

Expression 1: Sum(Sales)

Expression 2: (Sum(Sales) - Sum({<Year = $(=Max(Year)-1)>}Sales)  )/ Sum(Sales)

Selection: Year = 2018

I get this:

[nareshthavidishetty]

Hi,

I need to show with out selection.

Thanks..

[vishalarote]

Try this Expression

(sum({<Year={'2017'}>}Sales)-sum({<Year={'2018'}>}Sales))/sum({<Year={'2018'}>}Sales)

[vishalarote]

Some Changes Above Expression PFA

e.g SC:

[vishalarote]

Sorry by Mistake i am Sending Empty QVW

PFA