Max/Min Value in Pivot Table at 2 level

[sarasmonu]

Hi All,

I am looking to  get information of max and min sales respectively at Year level and Month level.

Example: Get the max/min sales value among all month of the Year and display that at Year level.

Likewise, display max/mix value among all days of the month and display that at Month level.

Thanks,

Monu

[sunny_talwar]

May be this

At year level

Sum(TOTAL <Year> Sales)

At year and month level

Sum(TOTAL <Year, Month> Sales)