Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to use Aggr(....) and I'm having problems. This is how I understand it works.
Max(
{ < Date = {"=Aggr(Date, @5)"} > }
@5
)
This code will make a table out of Date and @5 and find the max value of @5. The thing is, I need @5 to be an expression. How can I extract the max of the second column in my table created by Aggr? It doesn't seem to work with just the expression in the place of all the @5's, should that work?
Erm...I don't inderstand! What do you want your finished chart to show, exactly? Please give an example expression.
It's just for a variable. So I just need the one value.
Help me out here...please provide some specific examples and if possible some sample data. Makes helping you a lot easier...