Max and min value from pivot table

[#1]

Hi everybody! I need calculate the max and min value of a pivot table.

For example:

Date               Import

02/02/2020     200

03/03/2020      0

04/04/2020      50

05/05/2020      500

06/06/2020      0

Import is an expresión: sum(Sales)

In this case:

max: 500

min: 50 (without zero)

I tried with differents expresións but it don't work.

Thank you!!

[alexandros17]

Could you send an example document?

[rubenmarin]

Hi andres, where you want to show your max and min values?

In example, for a text box it can be:

Max Value: =Max(Aggr(Sum(Import), Date))

Min Value: =Min(Aggr(If(Sum(Import)>0, Sum(Import)), Date))

[ecolomer]

See this example

You can see the max and the min value for each branch

[#5]

Max Value: =Max(Aggr(Sum(Import), Date))  ---> It shows all in zero

Min Value: =Min(Aggr(If(Sum(Import)>0, Sum(Import)), Date)) ------> It shows all with "-"

I want to show the max and min values in the pivot table, as an expresión.

I attached the file qvw.

[rubenmarin]

Hi Andres, those expressions were to put in a text box.

You want to show max and min values in the same pivot table? how? a column with the min and other with the max? only show the dates with the min and the max values?

[#7]

I need to show max and min values in the same pivot table. One column with the min and other with the max

[rubenmarin · Accepted solution]

Not sure if this is what you want, please check attachment

[#9]

Great! It work now! Thank you!!