Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to create a dashboard in the below format.
Year | Month | Sales by Month | Sales by Year |
---|---|---|---|
2017 | Jan | 100 | 500 |
2017 | Feb | 200 | 500 |
2016 | Jan | 300 | 1000 |
2016 | Feb | 400 | 1000 |
In this dashboard the Sales by Month measure will be calculated based on Year and Month, i.e., in the example above, for Jan 2017 the sales is 100, for Jan 2016 sales is 300 etc. The Sales by Year value needs to calculated based on the year only, i.e., in the example above, the total sales for 2017 for all the months Jan-Dec is 500, the total sales for 2016 for all the months from Jan-Dec is 1000. For Sales by Year, the value always needs to show the sum for all 12 months irrespective of the months selected in the filter.
Can anyone please let me know how to calculate the Sales by Year value.
Thanks,
Rajarshi
For Year 2017 Total sales for year is 300 and for Year 2016 is 700 but in sample it is
2017- 500
2016- 1000
Hi Anand,
In this part the user has selected only Jan and Feb in the filter. so data is shown only for the two months. But the Sales by Year value need to the sum of all months from Jan-Dec always irrespective of the months selected in the filter. So, I have put here the value for 2017 as 500 which is Jan+Feb+Mar+Apr+May+Jun+Jul+Aug+Sep+Oct+Nov+Dec.
Then make changes in the expression
Dim:- Year, Month
Expre:- Sum(Sale)
Expre:- =Sum( TOTAL <Year> Sales)
OutPut:-
Find Attached
May be this Expression
If(Sum(Sales) <> 0,Sum({<Month>} TOTAL <Year> Sales))
Regards,
Antonio