Hey i am trying to create a pivot table as given in the excel being attached
And also i have create a data mapping for material description
if( Match([MM Material Grp Desc],'Condensing Units','Evaporating Units'),'REF UNITS',if([MM Material Grp Desc]='Mortury','Mortury','Insulation'))as Description,
if( [A/c assign.]=2,'MFG Products',if( [A/c assign.]=1,'Traded Product',if([Sales Order Type]='ZINS','Installation',if( WildMatch([WBS Element],'DEF*'),'Others'))))as TYPE,
So the wildmatch doesnt function in this case as i want to.
Like i will be able to Show Others under the Profit Center table if the Wildmatch function works.
Let me know.Thanks.Really Urgent!!