https://community.qlik.com/t5/App-Development/Qliksense/m-p/1596224#M63120 <P>Hi ,</P><P>I want to count the distinct people id in a pivot&nbsp; table for each column , also i want to exclude the people id's that were present in the prior columns of the pivot table.</P><P>i'm using the below expression for getting the count:</P><P>COUNT(DISTINCT {&lt;[Cumulative LTV - First Order Date_MS]={"&gt;=$(vMinCM)&lt;=$(vMaxCM)"}&gt;} [Cumulative LTV - PeopleID])</P><P>This count includes id's from the previous columns which i dont want.</P><P>would like to achieve this through expression.</P><P>Attached is the image of the current setup.</P><P>Any help is much appreciated.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 02 Apr 2021 07:59:05 GMT ashishs_1 2021-04-02T07:59:05Z https://community.qlik.com/t5/App-Development/Qliksense/m-p/1596224#M63120 <P>Hi ,</P><P>I want to count the distinct people id in a pivot&nbsp; table for each column , also i want to exclude the people id's that were present in the prior columns of the pivot table.</P><P>i'm using the below expression for getting the count:</P><P>COUNT(DISTINCT {&lt;[Cumulative LTV - First Order Date_MS]={"&gt;=$(vMinCM)&lt;=$(vMaxCM)"}&gt;} [Cumulative LTV - PeopleID])</P><P>This count includes id's from the previous columns which i dont want.</P><P>would like to achieve this through expression.</P><P>Attached is the image of the current setup.</P><P>Any help is much appreciated.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 02 Apr 2021 07:59:05 GMT https://community.qlik.com/t5/App-Development/Qliksense/m-p/1596224#M63120 ashishs_1 2021-04-02T07:59:05Z