Good Morning,
I am trying to create two different row fields based off a single column from my source data table. I want to do this without using helper columns. In the provided example sheet I essentially want to be able to use my top source data table to output the bottom pivot table.
I have already got two formulas that separate the data the way I want,
With the code for Major being:
And the code for Minor being:Please Login or Register to view this content.
However, I can only put these fields into the Values field, I want them to be able to be placed into the Rows field. How can I accomplish this?Please Login or Register to view this content.
Bookmarks