Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have customers with their respective creation date, type of customer
how can I create a KPI that shows only customer for a certain type AND for previous month ( October 2019) without using filters?
Previous month :
=count(if(Month=month(Today())-1,[SAP# (Sold to)]))
I tried :
Count({<[Wholesale/Franchisee/Indirect Wholesale/Consignment] = {'WH'}, Month= (month(today())>} [SAP# (Sold to)])
Hi
Try this
Count({<
[creation date]={">=$(=Date(Monthstart(AddMonths(Today(),-1)))) <=$(=Date(MonthEnd(AddMonths(Today(),-1))))"},[Wholesale/Franchisee/Indirect Wholesale/Consignment] = {'WH'}
>}[SAP# (Sold to)])
Hope this helps
Thanks