Can we write this query as Dimension axis while visualization from above dataset?? "Customers whose SellType is PRMOT then SalesValue > 0 and for those customers if SellType is NORMAL then SalesValue == 0"

[#1]

Hi Friends,

Customer	SellType	SalesValue
XG970201	NORMAL	0
XE355501	PROMOT	1453
XE711301	NORMAL	0
XE355501	NORMAL	0
XF970201	PROMOT	0
XE530601	NORMAL	0
XE653901	NORMAL	0
XE653901	PROMOT	108756

Can we write this query as Dimension axis while visualization from above dataset??

"Customers whose SellType is PRMOT then SalesValue > 0 and for those customers if SellType is NORMAL then SalesValue == 0"

Thanks,

Bibhuti

[Anonymous]

I think you would be required two chart for same.

One chart would be showing SalesValue>0 & another would be showing SalesValue=0

Dimesnsion:  only({<SellType={'PRMOT'}>} Customer)  

Expression: If(SaleValue>0,sum(SalesValue))

Similarly for another condition...