Add text in value area of pivot table

ElisabethC

New Member
Joined
Mar 14, 2017
Messages
4
Hi,

What I'm trying to do may not be possible, but maybe you can help or find a workaround:

In a pivot table I want to display a lot of project data coming from Project OLAP cubes: start date, end date, health indicators,... all values based on numbers.
Additionally I would like to display the project owner's name as a second column next to the first column with the project name.
(FYI: if I add it as a 2nd row in the pivot table, I always have two separate lines that I would like to avoid)

To get my start date and end date displayed as a value, I used the workaround of the calculated fields. Is there any workaround or trick to reach something similar for text?

Thanks a lot for your help!

Elisabeth
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,911
Messages
6,175,334
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top