Oracle Analytics Cloud

Hi!

Using a pivot table in OAC, I would like to use the folder name as separate rows of a pivot table vertically

For ex.

NAME    |   LEVEL |                   |     1-2022    |   2-2022     |   Grand Total
JOHN         Best          
                     Total Number           3                5              8
                     Cost                   $2               $7             $9
            Medium
                     Price                  $5               $0             $5
             Low        
                     Score                  8                18             26

Where Best, Medium and Low are Folder Names and Total Number, Cost, Price, Score are Column Names under the Folder Names.
Name, Total Number, Cost, Price and Score contains data from our db connected to oac. Best, Medium and Low are just folder names

However, when I turn on Display Folder & Column Headings as Separate Rows it seems to show as separate columns like ex.

NAME | BEST | MEDIUM  |LOW
JOHN                          Total Number 
                              Cost
                              Price 
                              Score

I'm wondering if there is a way to get it like the first example where folder names are separate rows in the same column and the column names are in there own column?

Thanks so much!