Countifs

[bhaddour]

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)])

[Kashyap_R]

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