help in rolling 12 using rangesum in Adhoc report

[aniketsr]

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.

kush141087‌

[zhadrakas]

you could build seperate Bookmarks and use them in your reports

[aniketsr]

Hey Tim,

Sorry My bad i meant Adhoc Report and not custom report.

[senpradip007]

Try like :

Sum({<Date<={$(=AddMonths(max(Date),-12))}>} [Value Field])

[aniketsr]

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

[Kushal_Chawda]

Please post your sample application

[aniketsr]

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.

[aniketsr]

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.

[aniketsr]

Hi kushal,

Attached is the sample QVW.

I tried using Concat and GetFieldSelections but the output is null.

[aniketsr]

pls refer this attachment.

kush141087‌