• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Numbers Text in Pivot Table (not Alphanumerical)

srinidhi

Active Member
I want the numbers (sum) as well as text to appear in the Pivot table,

The column has Month & in some months the numbers need to appear & in some text, the base data from where the pivot is linked is in the same format like numbers for some months & texts for some month, but Pivot cant display the text directly from source data. I went through this blog & found the solution, but it is restricted to 3 or 4 texts, I have around 12 different texts to be displayed.

Is it possible??? I tried applying conditional formatting to pivot table with texts in it , but did not succeed. Any help is appreciated
 
Srindi


In the same post you mentioned there was a comment with a link to a site which has a VBA solution for a Text Pivot Table replacement
 
Thanks, Hui,Thanks for the reply


I was wondering is it possible by conditional formatting as I need to develop this workbook & pass it on to people, many of them dont even know want a macro is.....
 
Back
Top