Customer Analysis

[Jenks]

Hello Qlik Team,

I am trying to create some customer analysis and all the expression I have tried dont appear to return the right values.

What I would like to show in a table is

                                   Total Customers    Customer spending >$1m  Customers Spending between $500k-$999k

Quarter 1

Quarter 2

Quarter 3

Dimensions are Quarter,, Customer.  Measures Revenue $M

Any ideas?

Thanks, Jenks!