N-Printing Filter Selection with aggregation

Anonymous — Tue, 31 Mar 2015 14:43:55 GMT

I have below issue in n-Printing..

Need to execute below expression to bring in this output in to Year and Month filter selections

Year: aggr(max({<[KPI Type]={'Market Share'}Calendar Year]),[Europe Region])

Month: Date(aggr(Max({<[KPI Type]={'Market Share'}>}[Calendar Month And Year Number]),[Europe Region]),'MM')

please find attachment..

I can use ‘KPI Type’ as Market Share in selection. How can I aggregate with Europe Region? I tried to bring this in different ways but could not!!

I need to aggregate it to Europe Region because I have different Months and Year for latest in a Region, please find below.

Re: N-Printing Filter Selection with aggregation

lironbaram — Mon, 20 Jul 2015 06:32:19 GMT

hi you can do it

but there is something odd with your filter it might result in an array and not a single value

as you use aggr function

any how you can do it like this

in the year filter insert this

=Year=max(aggr(max({<[KPI Type]={'Market Share'}[Calendar Year]),[Europe Region]))

make sure you keep the evaluate or is numeric empty

for the month

=Month= Date(max(aggr(Max({<[KPI Type]={'Market Share'}>}[Calendar Month And Year Number]),[Europe Region])),'MM')