Set Analysis

[nicolett_yuri]

I have a table with MONTH, WEEK, DAY, PRODUCT and VALUE

I created a graph with dimension MONTH and PRODUCT, I need the VALUE of the biggest day of the month. (This value will be used to perform other account)

Problems encountered: When do the set analysis to catch the biggest day of the month, he does not respect the month dimension. Only respect when I select one month.

Expression used: SUM({$<DATA = {$(=max(DATA))} >} VALOR)

I've tried to use AGGR, FIRSTSORTEDVALUE, but had no success.

Follow the example application.

Thank you!

[nicolett_yuri · Accepted solution]

I solved the problem without using Set Analysis:

Sum( If( DATA = Aggr( Nodistinct Max( DATA ), MES, PRODUTO ), VALOR ) )

But if someone solve otherwise post here!