excluding records in the script

[#1]

Hello All,

I have a product_id for which want to only include data till 2015,

but for 2016 i dont want to include that in the script.

for example only include data for product_id 126 till 2015 not in 2016.

How can i do this in the script?

Please help.

Thanks & Regards,

Jaya

[#2]

Hello Sunny,

The expression you gave does not work and i am not able to troubleshoot it.

please help.

I need to exclude all the records for product_id 126 for the year 2016 from the straight table.

Need help on this urgently.

Thanks & Regards,

Jaya

[#3]

Hello Sunny,

This expression works

count(distinct(aggr(only({<lproduct_id-={'956'}>}order_id),order_id)))

now i need to add the Year = 2016 field in this expression.

I am not able to figure that out.

Please help.

Appreciate your help as always.

Regards,

Jaya

[sunny_talwar]

This?

Count(DISTINCT Aggr(Only({<lproduct_id-={'956'}, Year = {2016}>} order_id), order_id))

or

Count({<Year = {2016}>}DISTINCT Aggr(Only({<lproduct_id-={'956'}>} order_id), order_id))