Max in pivot table

[#1]

Hi every one,

Cd    Pid         txt  year     Id      max(sales)

E       1872       C     1      111     1000

E  .    1872       C     1      222     20000

Above is pivot table. I need max(sales) from the above.

Result:

E  1872  C  1  222   2000

Thanks

[miguelbraga]

Hey there,

I guess there is a problem between your pivot table and your desired result.

Regards,

MB

[sunny_talwar]

Where are you looking to get that row in? Pivot table itself or in a text box object?

May be like this in the pivot table:

If(Max(Sales) = Max(TOTAL Sales), Max(Sales))

Assuming Cd, Pid, txt, year, Id are all dimensions.