Max/Min Value in Pivot Table at 2 level

sarasmonu — Fri, 22 Jun 2018 16:07:04 GMT

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

Re: Max/Min Value in Pivot Table at 2 level

sunny_talwar — Fri, 22 Jun 2018 16:10:23 GMT

May be this

At year level

Sum(TOTAL <Year> Sales)

At year and month level

Sum(TOTAL <Year, Month> Sales)