how to use max function as below please help me on this

[sonysree88]

Hi all,

I need the expression like below how to get ,Can you please give me solution for this.

Max(expression1 something like sales]/(Budget expression)-(discount expression))

Max((exp1)/(exp2))

i have to do the variance of 2 expression and i want to get the max values of it.

How do i achieve this.

Regards

Sonysree

[swuehl]

If your expressions are aggregations, you would need advanced aggregation and a grouping entitiy (dimension(s) 😞

Something like

=Max( Aggr( Sum(Sales) / Sum(Budget), Customer))