Display Max(Amount), Invoice Number, Carrier Name

[#1]

Hi

I have attached my requirement, can any one help...

Regards

Joe

[#2]

Hi,

please can you be more clear on what do you need?

Andrea

[#3]

Dear Danielato,

I have a dimentions like Amount, Invoice Number, Carrier Name.

Using a Max expression I got the maximum of Amount but I neet to show the the Maximum of Amount to which invoice and Carrier name.

I hope its clear for you..

Thanks

Joe

[#4]

Hi,
Shouldn't a straight table with dimension Carrier Name and Invoice, and sum(max(Amount)) as expression do the trick?

/@Ungvall

[#5]

Hi,

I could't understand it, I would like to use this expression in a pivot table.

Thanks in advance

Joe

[#6]

Hi,
If I understand you correctly - try If(max(Amount) Invoice Number) and If(max(Amount) Carrier Name)...

/@Ungvall

[#7]

Dear Ungvall,

I have attached my requirements in the orginal post.

Can you solve it.

Thanks in advance.

Joe

[#8]

Hi vmjoe1978,

Of course what you want is not possible in this case!

The table you make in you load script is not good enough.

You have to load a table like:

Carrier          Invoice          Amount

A               101               10

B               102               20

B               101               30

C               103               10

A               101               20

C               103               30

B               103               30

C               103               20

A               100               10

Then you can make what you want

Carrie         Invoice          Total

A               100               10

A               101               30

B               101               30

B               102               20

B               103               30

C               103               60

I hope this helps!

Kind Regards,

Martijn