Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Not applicable

## How to make a Pivot Table like in this example?

Please help me to make a Pivot Table like this one:

I believe it is a Pivot Table with groups. I've been reading in the community of any ideas how to make one like this but I can't find clear instructions.

I only have one dimension and one expression:

 AREA Sales GMM East 6249006 GMM North 8756996 GMM South 10315633 GMM West 1415876

Thanks for the help!

1 Solution

Accepted Solutions
MVP

Like this?

Script used:

Table:

SubField(AREA, ' ', 1) as Field1,

SubField(AREA, ' ', 2) as Field3,

If(Match(SubField(AREA, ' ', 2), 'South', 'North'), 'Section 1', 'Section 2') as Field2

INLINE [

AREA, Sales

GMM East, 6249006

GMM North, 8756996

GMM South, 10315633

GMM West, 1415876

];

4 Replies
Creator II

Depending on your data model, you could concatenate your dimension to be

GMM fieldname & ' ' &Direction fieldname

or create an expression for each

1.Sum({\$<Fieldname1 ={'GMM'}, Fieldname2 ={'East'}>}Sales)

2. Sum({\$<Fieldname1 ={'GMM'}, Fieldname2 ={'North'}>}Sales)

3. Sum({\$<Fieldname1 ={'GMM'}, Fieldname2 ={'South'}>}Sales)

4. Sum({\$<Fieldname1 ={'GMM'}, Fieldname2 ={'East'}>}Sales)

And have the expression name as GMM East

MVP

Like this?

Script used:

Table:

SubField(AREA, ' ', 1) as Field1,

SubField(AREA, ' ', 2) as Field3,

If(Match(SubField(AREA, ' ', 2), 'South', 'North'), 'Section 1', 'Section 2') as Field2

INLINE [

AREA, Sales

GMM East, 6249006

GMM North, 8756996

GMM South, 10315633

GMM West, 1415876

];

Partner - Master

HI.

You would have to make the structure in Script.

Data:

Sales

LEFT(AREA,3) as GMM

SUBFIELD(AREA,' ' ,2) as Area

IF(SUBFIELD(AREA,' ' ,2)  = 'South' OR SUBFIELD(AREA,' ' ,2)  = 'North',

'Section 1',

'Section 2') as Section;

From YourData.

You then just add the individual fields to your Pivot.

Mark

Not applicable
Author

Hi,

You can create the required 3 fields from "AREA" in the script itself..

Community Browser