Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I'd like to exclude to items from my dimension.
using:
=If(ListItemsFromID_Project <> 'Irish Rail Drogheda to Greystones Onboard', 'Irish Rail Drogheda to Greystones Trackside', ListItemsFromID_Project)
not getting desired result.
Any ideas?
Thanks
Possibly two ways at the frontend
1) As calculated Dimension and suppress when the value is null
IF(not Match(ListItemsFromID_Project,'Irish Rail Drogheda to Greystones Onboard','Irish Rail Drogheda to Greystones Trackside'),ListItemsFromID_Project,Null())
2) In the expression as below
{<ListItemsFromID_Project-={''Irish Rail Drogheda to Greystones Onboard','Irish Rail Drogheda to Greystones Trackside'}>}
@BrunPierre
I need to exclude items 'Irish Rail Drogheda to Greystones Onboard' and 'Irish Rail Drogheda to Greystones Trackside', from my dimension.
So that they do not show in the bar chart.
Does this explain a bit better?
using:
=If(ListItemsFromID_Project <> 'Irish Rail Drogheda to Greystones Onboard', 'Irish Rail Drogheda to Greystones Trackside', ListItemsFromID_Project)
Thanks
Possibly two ways at the frontend
1) As calculated Dimension and suppress when the value is null
IF(not Match(ListItemsFromID_Project,'Irish Rail Drogheda to Greystones Onboard','Irish Rail Drogheda to Greystones Trackside'),ListItemsFromID_Project,Null())
2) In the expression as below
{<ListItemsFromID_Project-={''Irish Rail Drogheda to Greystones Onboard','Irish Rail Drogheda to Greystones Trackside'}>}
@BrunPierre , Magic.
I used calculated dimension! it worked nicely!
thanks a million!