14 Replies Latest reply: Jun 17, 2015 1:20 PM by raghu bharath

HOW TO DO GROUPING IN STRAIGHT TABLE?

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?

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

You can add a calculated dimension like this:

=if(CBU='DMIN' or CBU='RA' or CBU='SV','AD',CBU)

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

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

grouping dimension values

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

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

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)

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

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

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

ECOM AND ERWIN

i DONT WANT THEM

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

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

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

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

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

CAN I VIEW IT SIMILAR TO THIS EXCEL FILE

IF I CLICK ON +

CAN I VIEW THE ROLL UP FIELDS

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

For the +sign option, use a pivot table with two dimensions, the first where you do the grouping, second dimension CBU.

For clarity, can you please make a new thread for new questions?

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

OK

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

Can you explain in more detail.

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

Not sure for what you want more detail... but in general tab change the chart to pivot table instead of straight table, then the first dimension with the grouping expression and then add a second dimension with field CBU

• Re: HOW TO DO GROUPING IN STRAIGHT TABLE?

For the sorting I think you can use in the sort tab of the properties, sort by expression something like

=wildmatch(CBU,'RA','SV',......othervalues)