Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...