ABOUT FILTERING

[janardhan]

Hi friends ,

i have some itemid like 10 ,20 ,30 ,40 ,50 ,60 ,70 . i need to pick some of them like 20 ,30 ,50 ,60.

i need to display those itemids mentioned and with their respective data.

Please help me.

Thanks in Advance

jana

[janardhan]

i have to dispaly in straight table or in pivot

[janardhan]

i am attaching the example , pls find it

[janardhan]

as shown in the image , i need display only OTG180 , OTG191 , OTG179

[janardhan]

I need to display total for selected itemids

[MayilVahanan · Accepted solution]

Hi

If i understood your requirement correctly means, you want to display the

OTG180 , OTG191 , OTG179 items and its respective data alone in straight table always?? If so,

In expression ,

Try like this:

=Sum({<ItemId={'OTG180' ,'OTG191','OTG179'}>}LineAmount)

So from this, its always so the three ItemId alone in the table. If not, please try like Gysbert Wassenaar suggestion.

Regards,

R.MayilVahanan

[janardhan]

Thanks for ur help.....

[janardhan]

if u dont mine...

can i write like this in the expression

otg50 – otg175 + otg182-otg192 + otg193-otg196

[MayilVahanan]

HI

Try like this

=Sum({<ItemId={'OTG182' ,'OTG193','OTG50'}>LineAmount)-Sum({<ItemId={'OTG192','OTG175','OTG196'}>}LineAmount)

Hope it helps

[janardhan]

Thanks Ram..