Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to find the sales Growth in percentage?the below image is sample one.
You can use your formula with the metrics that you have or in which dimention you calcualte the sales growth like Year, Month, Quarter according to that use the formula
Ex:-
( sum([MT Value]) - (sum(Previos Quarter value [MT Value])))
/
sum(TOTAL [MT Value])
In this formula it is sales growth for Quarter only.
Regards
Anand
[MT Value] - means Which one?
This is example you can use your metrics
Ex:-
( sum([Your MetricValue]) - (sum(Previos Quarter value [Your MetricValue])))
/
sum(TOTAL [Your MetricValue])
Regards
Anand
[Previos Quarter value] have indicate error.Which one is [Previos Quarter value]
Hi Stefen,
Basic growth formula for sales growth is below expression but it depends on which dimension you use this expression like Year, Month and Quarter.
Suppose you want to calculate growth for current year versus previous year then
1. Fetch the current year sales value set some variables
vYTD = Year = {$(=Max(Year))}
This will calculated by expression Sum({$<$(vSetYTD)> } [Sales Value])
2. Then create variable for the previous year Sum({$<$(vSetLYYTD)> } [Sales Value])
3. Then after all this use both expression in the gauge chart like
Ex:-
(Sum({$<$(vSetYTD)> } [Sales Value])
/
Sum({$<$(vSetLYYTD)> } [Sales Value]))
- 1
Note:- You have to use Metrics it is example i assume and fields and variables are different in your app also
Regards
Anand