Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have my data coming in at month(Ex:Apr-15) and i have a date table with month,quarter and year.I am trying to get a measure at quarter level but it has to be dynamic based on a month selected by the end user.For example user would select Apr-15 and the measure should calculate the amount of Q2-15.
My measure for month is Sum({<scenario ={'ACTBUD'})>} amount),simple as month is a selected value,how do i get the quarter value based on the month selection.
Thanks.
May be this"
Sum({scenario = {'ACTBUD'}, Quarter = p(Quarter), Month = >} amount)
Where
Quarter = p(Quarter) will include the whole quarter and
Month = will ignore any selection in Month field
May be this"
Sum({scenario = {'ACTBUD'}, Quarter = p(Quarter), Month = >} amount)
Where
Quarter = p(Quarter) will include the whole quarter and
Month = will ignore any selection in Month field
Thanks Sunny
No problem Sujan