David Evans
Active Member
Hi Folks - I've not touched PP in over a year and I'm rusty as heck ...
With the attached data, I want to be able to do the following -
-SUM([Amount]) by Cust No
-COUNT([AccountNo]) by Cust No
Group Customers by Amounts, for example, <1.0M;1-3M;3-5M; etc ...
What's the best approach?
PS I know the data is not in the PP Window - I can get it there! But can't decide whether to use Calculated Columns or Measures .... or some other special sauce ....
As usual - all contributions gratefully accepted ...
With the attached data, I want to be able to do the following -
-SUM([Amount]) by Cust No
-COUNT([AccountNo]) by Cust No
Group Customers by Amounts, for example, <1.0M;1-3M;3-5M; etc ...
What's the best approach?
PS I know the data is not in the PP Window - I can get it there! But can't decide whether to use Calculated Columns or Measures .... or some other special sauce ....
As usual - all contributions gratefully accepted ...