Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
i have to dispaly in straight table or in pivot
i am attaching the example , pls find it
as shown in the image , i need display only OTG180 , OTG191 , OTG179
I need to display total for selected itemids
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
Thanks for ur help.....
if u dont mine...
can i write like this in the expression
otg50 – otg175 + otg182-otg192 + otg193-otg196
HI
Try like this
=Sum({<ItemId={'OTG182' ,'OTG193','OTG50'}>LineAmount)-Sum({<ItemId={'OTG192','OTG175','OTG196'}>}LineAmount)
Hope it helps
Thanks Ram..