Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sarasmonu
Creator
Creator

Max/Min Value in Pivot Table at 2 level

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

1 Reply
sunny_talwar

May be this

At year level

Sum(TOTAL <Year> Sales)


At year and month level

Sum(TOTAL <Year, Month> Sales)