Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...
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...
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.
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)
I forgot, I had to take off the 'a' so:
Emp Value
Another Name (b,c Together) 5000
d 6000
Thanks.
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.