https://community.qlik.com/t5/App-Development/Bypassing-while-using-Aggr-in-Pivot-table/m-p/2426928#M96232 <P>=sum(aggr<BR />(count({&lt; CalendarMonthNum=,CalendarYear=,Date=, BookingStatus={'Booking','Booked','Car Allocated'}&gt;}distinct(Booking_ID)),<BR />RM_Name,AM_Name,DealerCode,City_Name,Model,ModelCode))<BR /><BR />The above measure is an expression Pivot Table.<BR />I have 2 doubts :-</P> <P>1) This expression is not able to bypass the fields.</P> <P>2) I want to add 1 more dimension in my pivot . However, whenever I add the same in aggr function along with rest of the fields , my total value changes .&nbsp;</P> Tue, 05 Mar 2024 07:20:35 GMT Ishaan_Kumar 2024-03-05T07:20:35Z https://community.qlik.com/t5/App-Development/Bypassing-while-using-Aggr-in-Pivot-table/m-p/2426928#M96232 <P>=sum(aggr<BR />(count({&lt; CalendarMonthNum=,CalendarYear=,Date=, BookingStatus={'Booking','Booked','Car Allocated'}&gt;}distinct(Booking_ID)),<BR />RM_Name,AM_Name,DealerCode,City_Name,Model,ModelCode))<BR /><BR />The above measure is an expression Pivot Table.<BR />I have 2 doubts :-</P> <P>1) This expression is not able to bypass the fields.</P> <P>2) I want to add 1 more dimension in my pivot . However, whenever I add the same in aggr function along with rest of the fields , my total value changes .&nbsp;</P> Tue, 05 Mar 2024 07:20:35 GMT https://community.qlik.com/t5/App-Development/Bypassing-while-using-Aggr-in-Pivot-table/m-p/2426928#M96232 Ishaan_Kumar 2024-03-05T07:20:35Z https://community.qlik.com/t5/App-Development/Bypassing-while-using-Aggr-in-Pivot-table/m-p/2427843#M96303 <P>include the by passing in the sum:<BR />sum({&lt;<SPAN>CalendarMonthNum=,CalendarYear=,Date=&gt;}aggr(count({&lt;CalendarMonthNum=,CalendarYear=,Date=,....</SPAN></P> Wed, 06 Mar 2024 14:57:44 GMT https://community.qlik.com/t5/App-Development/Bypassing-while-using-Aggr-in-Pivot-table/m-p/2427843#M96303 ali_hijazi 2024-03-06T14:57:44Z