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
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