Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi,
Perhaps the following will give a good start:Current Years Current Month Vs Last Year Same Month Data
Please share the logic.I have tried but its not working.
Thanks..
(Sum({<Year = {$(=Max(Year)-1)}>}sales)-Sum(sales) ) / Sum(sales)
Works, considering you have a selected year (2018 for instance) and month.
Hi,
Please find below .
I need to show some thing like this.
Thanks..
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:
Hi,
I need to show with out selection.
Thanks..
Try this Expression
(sum({<Year={'2017'}>}Sales)-sum({<Year={'2018'}>}Sales))/sum({<Year={'2018'}>}Sales)
Some Changes Above Expression PFA
e.g SC:
Sorry by Mistake i am Sending Empty QVW
PFA