Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try:
sum(sales_total)*avg({<CalendarMonthAndYear>}1)
Another option
Sum(sales_total) + Sum({1<sman_code = p(sman_code)>} 0)