Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HOW TO DO GROUPING IN STRAIGHT TABLE?
IN THIS IMAGE : I WANT TO GROUP DMIN,RA, SV UNDER AD AND DO ROLL UP.
CBU IS A DIMENSION.
CAN WE ACHIEVE THAT IN FRONT END?
Not sure if you want the same value for COD,COP,DOM or not, for different value
if(wildmatch(CBU,'DMIN','ERWIN'),'ECOM',Null()
,if(wildmatch(CBU,'DMIN','RA','SV'),'AD',
,if(wildmatch(CBU,'COD','COP','DOM'),'SomeValue',CBU)))
Same value
if(wildmatch(CBU,'DMIN','ERWIN'),'ECOM',Null()
,if(wildmatch(CBU,'DMIN','RA','SV,'COD','COP','DOM''),'AD',CBU))
You can add a calculated dimension like this:
=if(CBU='DMIN' or CBU='RA' or CBU='SV','AD',CBU)
You have 3 choices . I prefer #2 below.
1. Hard coded Dimensional expression.
if(wildmatch(CBU,'DMIN','RA','SV'),'AD',CBU)
2. On the fly Custom Groups (With IE Plugin & Ajax) - No Macros
Users can map/group dimensions at run-time!
3. On the fly (Only in IE) with Macros
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Thanks,
Phani
Hi Piet,
I have some rows like ERWIN AND ECOM, which i dont want them. how should I add that to statement
.
one more question :
I need to do same for COD, COP,DOM
how should i add that to this statement
=if(CBU='DMIN' or CBU='RA' or CBU='SV','AD',CBU)
Thanks phaneendra.kunche
Not sure if you want the same value for COD,COP,DOM or not, for different value
if(wildmatch(CBU,'DMIN','ERWIN'),'ECOM',Null()
,if(wildmatch(CBU,'DMIN','RA','SV'),'AD',
,if(wildmatch(CBU,'COD','COP','DOM'),'SomeValue',CBU)))
Same value
if(wildmatch(CBU,'DMIN','ERWIN'),'ECOM',Null()
,if(wildmatch(CBU,'DMIN','RA','SV,'COD','COP','DOM''),'AD',CBU))
ECOM AND ERWIN
i DONT WANT THEM
I see I misplaced a bracket
if(wildmatch(CBU,'DMIN','ERWIN','ECOM'),Null()
,if(wildmatch(CBU,'DMIN','RA','SV'),'AD',
,if(wildmatch(CBU,'COD','COP','DOM'),'SomeValue',CBU)))
Hope it helps
IN THE SAME EXAMPLE I WANT TO SORT THE DISPLAY:
RA
SV
DMIN
COD
CSM
ITSM
UIM
EMO
APM
DOM
API
EMM
MF
WA
AUTO
IN THIS ORDER
CAN I VIEW IT SIMILAR TO THIS EXCEL FILE
IF I CLICK ON +
CAN I VIEW THE ROLL UP FIELDS