? Calculate Billing consistency greater than 1 Lakh

[simran_mann]

Hi,

I have 4 fields :

Region, Year_Month,Code, Sales.

Calculate the billing consistency greater then 1 lakh in last 3 months.

• Billing  of  Count of Distinct Code is greater than 1 lakh in last 3 month for 1 time, those code should be represented in 1/3 column.
• Billing  of  Count of Distinct Code is greater than 1 lakh in last 3 month for 2 times, those code should be represented in 2/3 column.
• Billing  of  Count of Distinct Code is greater than 1 lakh in last 3 month for 3 times, those code should be represented in 3/3 column.

Please Find the attachment.

Thanks in advance.

[Digvijay_Singh]

Please share sample data/app to understand the problem you are facing.

[shiveshsingh]

Please share sample app.

[simran_mann]

Please find the Sample Report.