Max value within a pivot table

[mohamed_ahid]

Hi all,

suppose that we have a pivote table like this :

ID       name           V     MaxE                 Min E  

1        name1          24        3874              24

34      name2          398      3874              24

25      name3          293      3874              24

345    name4          872      3874              24
2        name5         873       3874              24

5        name6         3874     3874               24

V=sum (value of transactions )  for week 12 and 11 /   sum (value of transactions )  for week 9 and 10

how can i get max of V and min of v in the same table( i will use them after that in an expression)

THX

[maxgro · Accepted solution]

maybe (replace sum.... with your expression for V column)

max(total

     aggr(

          sum (value of transactions )  for week 12 and 11 /   sum (value of transactions )  for week 9 and 10, 

          ID, name

          )

     )

[MK_QSL]

What are the dimension in this table?

You can get the max by

Max(Total Aggr(YourExpression,Dim1,Dim2....etc))

[Anonymous]

Try something like the below as expressions in your Pivot Table for MaxE and MinE :

Max( TOTAL aggr ( sum(V) , ID) )

Min ( TOTAL aggr ( sum(V) , ID) )

For sum(V) will have to put in instead your expression that you want the Min & Max of.

Not sure if I have explained that well, so see attached example qvw.

[mohamed_ahid]

Thank you everybody ,you were perfect !