Need Help in Pivot Table!!!!

[vermapardeep]

Hi All,

I need to create a Pivot table of a data where I have some values as %s and some values are as Numeric. I need to show data in pivot table as %s where data value as % and data as numeric where data values are numeric.

I have created a new variable where I have multiplied the data values with 1 and format the cells with existing number format so that when I take sum in data value pivot table treat this data as text and show the as it is value on pivot.

But I am getting the values in pivot table as Numeric only.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Attribute[/TD]
[TD]Data[/TD]
[TD][TABLE="width: 143"]
<tbody>[TR]
[TD="width: 143"]Driver[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Year[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Target Group[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49"]Trick[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]To be a leader or manager of people[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 151"]
<tbody>[TR]
[TD="class: xl65, width: 151, align: right"]24%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<tbody>[TR]
[TD="width: 143"]Career Goals[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Business[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]=IFERROR(B2*1,"")[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]To be a technical or functional expert[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 151"]
<tbody>[TR]
[TD="class: xl65, width: 151, align: right"]6%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<tbody>[TR]
[TD="width: 143"]Career Goals[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Business[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]=IFERROR(B3*1,"")[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]To be a leader or manager of people[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 151"]
<tbody>[TR]
[TD="class: xl65, width: 151, align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<tbody>[TR]
[TD="width: 143"]Career Goals Rank[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Business[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]To be a technical or functional expert[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 151"]
<tbody>[TR]
[TD="class: xl65, width: 151, align: right"]9[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 143"]
<tbody>[TR]
[TD="width: 143"]Career Goals Rank[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64, align: right"]2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Business[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[ctd2015]

Having two different data formats in the same column might not be possible
You need to have the data in separate columns not separate rows