SetAnalysis

[duschking]

Hi i got a pivot table with 2 dimensions (rundate_placement3, rundate_placement3details) and a lot of dates (rundate_Date). i want just show the sum of costPerRundate_NettoNetto for the day (can be 1 week, a month or any date) following today..  it doesnt work. do yo usee why=

Sum({< rundate_Date = {"$(=(Aggr(Min({<rundate_Date = {">=$(=Today())"}>} rundate_Date), rundate_Placement3, rundate_Placement3Details)))"} >}
costPerRundate_NettoNetto
)

[rubenmarin]

Hi, the aggr will return one value for each combination of rundate_Placement3 and rundate_Placement3Details, you'll need to tell what to do with all those values, maybe you want the Min() outside the Aggr(), to keep the min value returned by Aggr(). Or maybe you want a Concat() that uses all the different values returned?

Another syntax error could be the use of double quotes inside double quotes, because the second double quotes will close the first one, instead of starting an enclosed double quoted sentence

{"$(=(Aggr(Min({<rundate_Date = {">=$(=Today())"}>} rundate_Date), rundate_Placement3, rundate_Placement3Details)))"} >}

If the value returnd by the $-Expansion is exactly equal to the value to filter, you can change the outside double quotes to simple quotes

Sum({< rundate_Date = {'$(=Min(Aggr({<rundate_Date = {">=$(=Today())"}>} rundate_Date, rundate_Placement3, rundate_Placement3Details)))'} >}
costPerRundate_NettoNetto
)

You can also try to use Chr(34) instead of the double quotes

Sum({< rundate_Date = {$(=Chr(34) & Min(Aggr({<rundate_Date = {">=$(=Today())"}>} rundate_Date, rundate_Placement3, rundate_Placement3Details))& Chr(34))} >}
costPerRundate_NettoNetto
)

In some situactions you can use doble-double quotes as an scape character, but one outside the $-expansion and the other inside, I think it won't work.

Sum({< rundate_Date = {"$(=Min(Aggr({<rundate_Date = {"">=$(=Today())""}>} rundate_Date, rundate_Placement3, rundate_Placement3Details)))"} >}
costPerRundate_NettoNetto
)