Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
I have these 'types' of data.
I am trying to sort this data into a few different groups within a different pivot table, kind of like this.
Except I also want to add a 4th group called 'Total' that has all of the 'Types'
This is how I was trying. Any help or suggestions?
=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 enable the total?
Hi Joshua,
Create another field with the expressions your using, something like:
Table:
Load
SaTy_OTIF,
// Other fields here,
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'
)
)
)
) as Group
From [Whatever];
in this way, you can put the dimension on the pivot table.
As to the total, you wouldn't need to create another field with a total qualifier. on the presentation tab of the pivot table, you can choose the "Totals" to create what you want.
Felipe.
This method still only shows the 'OUS', 'Domestic' and 'Internal / Warehouse to Warehouse' and not the 'Total'
Doing it this way seems to just show an average and not all of the data combined.
Are you look to show the Sum or the three numbers? 91.31% + 27.17% + 91.90% for On-Time?
If you look at the totals for the Comp Pivot, I am trying to use those values. So 'On-Time' for 'Total' would be 75610/81143 which is 93.2%
In-Full would be 94.6%
and OTIF would be 89.4%