Sum With Particular Products

[#1]

Hi Experts

I am Using a Pivot Table

in that I want to sum the sales for  particular [Product code] ones only,

How can I do it

Currently i used this but not yielding any results

sum(if([Product Code]= '155','156','157',158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176', Sales))

Please Suggest

[PrashantSangle]

Try

sum(if(Wildmatch([Product Code], '155','156','157',158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176'), Sales))

regards

[ankit777]

You can use pick match

[PrashantSangle · Accepted solution]

Hi,

Or you can try in set analysis like

sum({<[Product Code]={'155','156','157',158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176'}>}Sales)

Regards

[Kushal_Chawda]

try to use set analysis

sum({<[Product Code]= {'155','156','157',158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176'}>}Sales)