You can write Individual calculations to do that. Just Consider it an Element of a Dimension.
Thanks for the quick reply Deepak. Unfortunately, I'm not sure what that calculation would like like... I know how to create a calculated field but I don't know how to reference fields inside a pivot field. Maybe you could show me?
[Main Question] is the pivot field name
[INTERN] is the field I would like to use
Here's what I know at the moment: Under dimension I choose "Create Calculated Field"
What I don't know how to do yet is write the formulate that isolates the field [INTERN]
Thank you. Kate
Can you attach some sample workbook and Your Expectations?
Okay. I've attached some sample data. The workbook has a tab [Sample] - What I would like to do is created a calculated field that uses [INTERN] to further filter the data. So, create a calculated dimension [Q.INTERN] so I can use that field outside of the pivot field [Main Question]. Make sense? So then I can use the pivot data for displaying data for the Main Question and Sub Question as well as use the new calculated field for additional slicing.