Pls I need to have text instead of value in Values area in my pivot.
Is there a way, using macro, to have such a result?
Pivot text.xlsx
Pls I need to have text instead of value in Values area in my pivot.
Is there a way, using macro, to have such a result?
Pivot text.xlsx
If you only have 3 Textual values and each row item is unique then yes. You can use an additional value field and a custom number format.
If it get any more complex you will have to use alternative methods such as formula and VBA
Thanks Andy. For just these 3, works fine but I need to add some more (5 total). Can we use instead a macro?
Yes but that would be could to take a copy of the PT and replace known values with text. You can not alter the construct of the orginal PT.
That means, that in its final version it can not work as a usual Pivot?
Correct, as what you want is not possible with PTs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks