how to show a column that gets the percentage of growth or decline of sales of current month compared with previous period of last month?
for example today is feb 18, I would like the expression to get the sales of current month and then compare it with the same period of last month.
(jan 1 - jan 18)
to get sales of current month in a slice Im using this
EOMONTH([Date], 0) = EOMONTH(TODAY(), 0)
any help is much appreciate it.
For last month's slice, please try an expression, something like
AND(EOMONTH([Date], 0) = EOMONTH(TODAY(), -1) ,
DAY([Date])<=DAY(TODAY()))
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
13 |