IF Statement for Pivot Table

[joshrussin]

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'
    ))))

[Siva_Sankar]

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

[HirisH_V7]

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.