Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
I am trying to get the pivot table to show the data for a few groups of data, then also all of the data.
I have an IF statement that shows the 3 groups, now I want to add all of it in another IF statement. When I add all of it, it still only shows the 3 groups and not all of it.
Here is my statement.
=if(WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR'),'Internal / Warehouse to Warehouse',
if(WildMatch(SaTy_OTIF,'ZEU1','ZIN1'),'OUS',
if(WildMatch(SaTy_OTIF,'OR','UB'),'Domestic',
if(WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR','ZEU1','ZIN1','OR','UB'),'test'
))))
may be you dont have data that falls under all the groups. it may be easy if you share us the data or the example application that you have.
-Siva
Hi
There in the Calculated dim, your'e is using the same inclusions in other group too.so it not been displaying.
Try and create a inline load mapping for that particular field SaTy_OTIF,GroupingField.so that you can map the inline table with the Table in which your field is there.
HTH,
Hirish
PFA Example FYR.