=IF(product='A' OR product='C' OR product='E',product)
NOTE-- SELECT THE SECOND DIMENSION AND CHECK ON SUPRESS NULL VALUE
then output like this
week PRODUCT stock varient 1 A 0 3 2 C 0 1 3 E 0 1
test1.qvw 148.8 K
Thanks for your help.
It's getting close, but not quite worked how I wanted. I've attached the example. It gives me 2 in week 1, but this should be 3...? Any ideas..?
aggr_example.qvw 148.5 K