https://community.qlik.com/t5/App-Development/Customer-Analysis/m-p/1788726#M61596 <P>Hello Qlik Team,</P><P>I am trying to create some customer analysis and all the expression I have tried dont appear to return the right values.</P><P>What I would like to show in a table is</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total Customers&nbsp; &nbsp; Customer spending &gt;$1m&nbsp; Customers Spending between $500k-$999k</P><P>Quarter 1</P><P>Quarter 2</P><P>Quarter 3</P><P>Dimensions are Quarter,, Customer.&nbsp; Measures Revenue $M</P><P>&nbsp;</P><P>Any ideas?</P><P>&nbsp;</P><P>Thanks, Jenks!</P> Fri, 05 Mar 2021 14:44:39 GMT Jenks 2021-03-05T14:44:39Z https://community.qlik.com/t5/App-Development/Customer-Analysis/m-p/1788726#M61596 <P>Hello Qlik Team,</P><P>I am trying to create some customer analysis and all the expression I have tried dont appear to return the right values.</P><P>What I would like to show in a table is</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total Customers&nbsp; &nbsp; Customer spending &gt;$1m&nbsp; Customers Spending between $500k-$999k</P><P>Quarter 1</P><P>Quarter 2</P><P>Quarter 3</P><P>Dimensions are Quarter,, Customer.&nbsp; Measures Revenue $M</P><P>&nbsp;</P><P>Any ideas?</P><P>&nbsp;</P><P>Thanks, Jenks!</P> Fri, 05 Mar 2021 14:44:39 GMT https://community.qlik.com/t5/App-Development/Customer-Analysis/m-p/1788726#M61596 Jenks 2021-03-05T14:44:39Z