Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
We have created a custom report were we have used rolling 12 month logic in the expression.
for every selected dimension i have written separate expression due to which the for one metric i have to write 6 different expressions.
Can someone suggest a simpler way to do so.
Thanks in advance.
you could build seperate Bookmarks and use them in your reports
Hey Tim,
Sorry My bad i meant Adhoc Report and not custom report.
Try like :
Sum({<Date<={$(=AddMonths(max(Date),-12))}>} [Value Field])
Hi Pradip ,
The logic for rolling 12 is working fine but in the [Value Field] , how will it take the list of all the Pick Dimensions selected with a comma seperator
Please post your sample application
Hi
it just means that the user is empowered to decide what they wants to see. They can basically pick from multiple dimensions
below is my expression :
sum(aggr(RangeSum(Above( Sum({<MONTH_SHORT_NAME=,Year=>}Sales),0,12)),ID,Year,MONTH))
Whatever i select in the Pick Dimension should populate in the place of (ID,Year,MONTH) with a comma separator,
I just want to understand is there any possible way to do it.
Hi
it just means that the user is empowered to decide what they wants to see. They can basically pick from multiple dimensions
below is my expression :
sum(aggr(RangeSum(Above( Sum({<MONTH_SHORT_NAME=,Year=>}Sales),0,12)),ID,Year,MONTH))
Whatever i select in the Pick Dimension should populate in the place of (ID,Year,MONTH) with a comma separator,
I just want to understand is there any possible way to do it.
Hi kushal,
Attached is the sample QVW.
I tried using Concat and GetFieldSelections but the output is null.
pls refer this attachment.