Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I need to show year start month to selected month sales .
if apr-17 is selected then jan 17 to apr-17 sales need to be shown in bar chart
How to write this in set analysis...
Thanks
You also need to ignore your other filters, because your expression is now filtered by the Floor_Month_year field:
sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}, Year, Month, YearMonth, Datenum>}Sales)
Hi, try this
{< Month_Year, Date = {"$(='>=' & YearStart(Max(Date)) & '<=' & Date(Max(Date)))"} >}
If only a year 2017 is selected then jan to dec Months are showing as below
sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)
But when i selected any month (Apr-17) instead of showing Jan-17 to Apr-17 i getting below screen
I think i need to change some where in my expression
sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)
Any help regarding this
Any help on this issue plz
The better way is to create a textbox and see what these expressions give you
=floor(YearStart(Max(Floor_Month_year)))
=floor(Max(Floor_Month_year))
and what you have in Floor_Month_year
Hello,i did check that
both the expression are giving the correct values individually but when i combined them in a set analysis i am not getting the required output .
Did u see any issue in my expression .
sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}>}Sales)
before any month selection it is working fine ,the issue is when i select any month
Can you post these values?
When only Year(2017) is selected
when Year(2017) and Month(Apr) is selected
You also need to ignore your other filters, because your expression is now filtered by the Floor_Month_year field:
sum({<Floor_Month_year={">=$(=floor(YearStart(Max(Floor_Month_year))))<=$(=floor(Max(Floor_Month_year)))"}, Year, Month, YearMonth, Datenum>}Sales)
Hi, Juraj. You're right, I just can't figure out how the april selection gives january in the chart