Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello dears
i want find high and low value
i write
Min(Aggr(Sum(Value),Category))
or
Max(Aggr(Sum(Value),Category))
But incorrect
I expect a great record and display a small record (Two Record in one Table)
plz help me
Hi Leila,
The easiest way to achieve that table is using the load script instead. Please find the solution attached.
Hope it helps.
Alvaro P.
Are you looking for
=Max(TOTAL<Category> Aggr( Sum(Value), Category, SubCategory))
?
What is your expected outcome?
i expect Show a table with 2 record
FIrst Record is low (with value)
Second Record is high (with value)
see the attached
Thanks But i have only 2 Record Min And Max
Plz Help Me
Min Category
Max Category
Hi Leila,
The easiest way to achieve that table is using the load script instead. Please find the solution attached.
Hope it helps.
Alvaro P.
Please see the attached