Customers With out Sale

[kakani87]

Dear Folks,

I'm having data for  Sman's ,customer wise sale who is having 7 customers for Sman_code 001 and 4 for Sman 013

Now my requirement is to display the customer wise sale for Sman's  along with no sale customers for that months

For reference purpose in the month of August sale happened with 3 customers as displayed but Sman 013 has 4 customers where no sale happened with one customer as shown below in  table1 when filtered Month wise

Now I want to Display the 4th customer as well with sale as '0' to analyse Sman wise customer performasnce like that based on the month selection i want to display all the customers with both sale and no sale

Table1.

Month
Aug
Sep
Oct
Nov
Dec

Sman
001
013

Sman	Customer	sale
013	DA220	20103
013	DAA02	10789
013	DAA20	5916

Expected Output

Table 2:

Sman	Customer	sale
013	DA220	20103
013	DAA02	10789
013	DAA20	5916
013	DAB20	0

stalwar1‌

tresesco‌

tamilarasu‌

mrkachhiaimp‌

[tresesco · Accepted solution]

Try:

sum(sales_total)*avg({<CalendarMonthAndYear>}1)

[sunny_talwar]

Another option

Sum(sales_total) + Sum({1<sman_code = p(sman_code)>} 0)