2 Times Billing Customers

[marishnagendran]

Dear All,

I want to take last 6 months billing customers in that I want to calculate no.of billings if less than 2.

For Example:

Current Month we have to avoid

Name	Feb	Mar	Apr	May	Jun	Jul
A	1	0	1	0	0	0
B	1	1	1	0	0	0
C	0	0	0	0	1	1
D	0	0	1	1	1	1

1 indicates billing on that month

Customer A,C i want to show

[Ezirraffner]

Hi @marishnagendran ,

You can try like below:

1) Calculated dimension:

if(Aggr(RangeSum(Feb,Mar,Apr,May,Jun,Jul),Name)<=2,Name)

OR

1) Data Load

temp:
CrossTable (Month,Billing,1)
load * inline [
Name,Feb,Mar,Apr,May,Jun,Jul,
A,1,0,1,0,0,0,
B,1,1,1,0,0,0,
C,0,0,0,0,1,1,
D,0,0,1,1,1,1
];

2) with calculated dimension

if(Aggr(sum(Billing),Name)<=2,Name)

Hope this helps you.

Regards,

[marishnagendran]

Thanks for your reply Ezir

Name	Feb	Mar	Apr	May	Jun	Jul
A	1	0	1	0	0	0
B	1	1	1	0	0	0
C	0	0	0	0	1	1
D	0	0	1	1	1	1

In above attached Pivot table is using
Dimension as Customer
Column as Month
Expression as count({<Month = {$(=Max(Month)-6)}>}distinct Customer_Number)

From this Output i want to find no.of billing less than 2

[marishnagendran]

Any Idea??