-
1. Re: multiple number formats for pivoted data values?
Ken Flerlage May 17, 2018 6:09 PM (in response to Scott Laronge)If you're using the different formats on different sheets, then you should be able to format each pill separately in order to give different formats. If you need different formats on the same worksheet for the same pill, then that will require some creativity. You could duplicate the field (i.e. create a calculated field which just refers back to the original value), then place both on the sheet and format them differently.
-
2. Re: multiple number formats for pivoted data values?
Scott Laronge May 18, 2018 10:03 AM (in response to Ken Flerlage)But that's the thing. When you pivot the data from the data source you only have two fields: Pivot Table Values (green pill) and Pivot Table Names (blue pill).
So there is only one green pill for all values. Unless I break it out with the formula noted above.
-
3. Re: multiple number formats for pivoted data values?
Ken Flerlage May 19, 2018 11:46 AM (in response to Scott Laronge)Can you provide an example of what you are trying to do? Perhaps you could attach a packaged workbook?
-
4. Re: multiple number formats for pivoted data values?
Okechukwu OssaiMay 19, 2018 3:50 PM (in response to Scott Laronge)
If the data is already from a pivot table, It'll be tricky pivoting it again. I understand what you mean by having different data types in [Pivot Field Value]. Such data type mixture is an alarm bell that shows that you have over-pivoted the data or that the data wasn't properly structured in the first place.
Can you share a dummy sample dataset? It's either you don't need to add all the fields to the pivot or you could use calculated fields to move the different data types into separate categories.