Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi Community,
I wanted to find involved customers sales for Existing Customers, New Customers, and Closed Customer.
Existing Customers sales= Sum of sales of Current and Previous
New Customers sales = Sum of sales of Current Customers and should not include Previous Customers.
Closed Customers sales = Sum of sales of Previous Customers and should not include Current Customers.
In my Dashboards,
1. I have Master Calender
2. Showing Current month and Previous month like below
3. Above Selections, I am storing in variables and those are using set like below.
Have a look at
Thanks for the link. Here every thing need to change in Script part. Right now it is not possible to change script and I should do in Dashboard(front end) only.
Look at the first few expressions that Gysbert used. AFAIR there are front end only, using set analysis and p() and e() function. This should work well if you select two periods to compare.
customer count, new,lost, total
Hi
Please try these expression.
For new customer sales
sum({$<Year={$(vCurrentyear)},Month={$(vCurrmonth)},Customer=(P{1<Year={$(vCurrentyear)}>}Customer)>}Sales)
For Closed Customers sales
sum({$<Year={$(vPrvyear)},Month={$(vPrvmonth)},Customer=(P{1<Year={$(vPrvyear)}>}Customer)>}Sales)
For Existing Customers sales
sum({$<Year={$(vCurrentyear),$(vPrvYear)},Month={$(vCurrmonth),$(vPrvMonth0},Customer=(P{1<Year={$(vCurrentyear),$(vPrvYear)}>}Customer)>}Sales)