Calc Dimension Help

[pgalvezt]

Hello, I would like to show in 1 Pivote Table as follows:

Emp Value

a       1000

Another Name (b,c Together) 5000

d        6000

The idea is join and sum b and c and show them with another name.

I have Attached a Ex File.

Thank you.

[swuehl · Accepted solution]

You can use a calculated dimension

=if(Emp='b' or Emp='c', 'Other Name', Emp)

or even create a new field in the load script

LOAD

Emp,

Val,

if(Emp='b' or Emp='c', 'Other Name', Emp) as EmpPivotDim

FROM...

[john_duffy]

Hello.

I'm not sure if I fully understand the issue. 

Calc Dim.: if(match(Emp,'b','c'),'b and c',Emp)

Exp: Sum(Val)

John.

[#4]

Perhaps this in your loadscript?

LOAD
if(Emp='b' or Emp='c','anotherName',Emp) as newDimension,

* inline

[Emp, Val,
a,1000,
b,2000,
c,3000
d,6000];

See attached. Hope it helps...

(the same logic can also be applied to a calculated dimension, but I prefer fixing this in the loadscript for performance reasons on the frond-end side)

[pgalvezt]

I forgot, I had to take off the 'a' so:

Emp Value

Another Name (b,c Together) 5000

d        6000

Thanks.

[swuehl]

To group b and c together and take off a, try this as calculated dimension (or similar in the script):

=if(Emp = 'b' or Emp = 'c','Other Name',if(Emp <>'a',Emp))

and check 'Suppress When Value is NULL' in dimension tab.