vermapardeep
New Member
- Joined
- Nov 30, 2015
- Messages
- 7
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.
<tbody>
</tbody>
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.
Attribute | Data |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | =IFERROR(B2*1,"") | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | =IFERROR(B3*1,"") | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody>
</tbody>