Sign In

Welcome Back,

Signup/Login with your account

Don't have account,

You must login to ask a question.

You must login to add post.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Leave An Answer!
  • 1
RaviRaj Joshi
Beginner
Asked: 2023-02-20T14:32:35+05:30

How to calculate Month on Month or year on year change in self service?

I need to compare previous months sales numbers and show change (positive or negative) in chart for current year, can it be done using self service.

question
1 Answer

Leave an answer

You must login to add an answer.

1 Answer

Voted Oldest Recent
  1. Best Answer
    Beginner

    In Self Service create a calculated measure using below formula as per your dataset. Follow this URL for step by step guide on how to create a calculated measure : creating custom attribute and measure

    In this formula, I have taken retail sales data to calculate month on month sales:

    [Sales Amount] – (LAG([Property].[Sale Amount], 1) OVER (ORDER BY [Booking Date month]), 0) / (LAG([Property].[Sale Amount], 1) OVER (ORDER BY [Booking Date month]), 0)

    Like1 User
    • 0