Min and Max value?

[dmohanty]

Hi All,

I have an Inline table of data like this below:

Tab:

Load  * inline
[

Country, Year, Sales
A,2013,5
A,2014,5
B,2013,10
B,2014,10
C,2013,3
C,2014,2
D,2013,8
D,2014,7

];

I am showing a Straight Table to display Country and  Sum(Sales)

A10  B20  C5  D15

Now requirement is : In a Text Object, I have to show Min (Sales) and Max (Sales)

Min(Sales) = 5 for Country C

Max(Sales) = 10 for Country B

Also, if Year is Selected, the Min and Max value have to change accordinly as per Inline Data.

Please help to display the Min and Max value

Regards!

[CELAMBARASAN]

Did you checked

=Min(Sales)

and

=Max(Sales)

in Text object?

Any difficulties with that or I misunderstood?..

[Anonymous · Accepted solution]

PFA

Solution for the requirement.....

Regards

Nitin

[dmohanty]

Great!! Thanks Nitin.

Exactly this is what I wanted. Aggr() helped.

[dmohanty]

Hi Celambarasan,

NO, That won't help. I guess you missed a little.

Min(Sales) will give 2

Max(Sales) will give 10  which are not desired.

I had wanted  like this :

Min(Sales) = 5 for Country C

Max(Sales) = 10 for Country B

[Anonymous]

Welcome...

[#7]

just simply put min(sales) and max(sales) in text object.