title: Pivot table sorting by text string
body: <p>It seems so silly, but I am trying to set up my pivot table, and it doesnt seem to be my strongest side. </p>
  
  <p>The following picture demonstrates what I am after:</p>
  
  <p><a href="https://i.stack.imgur.com/kzw1t.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kzw1t.png" alt="enter image description here"></a></p>
  
  <p>... so basically in the data there is a currency string, however it seems as if I cant get this string to be represented in the matix - only in either the row labels or columns labels, which makes the table very unstructured. Is there a way to match the security (row label) with its denominated currency ? </p>
  
  <p>this part of my source table:</p>
  
  <p><a href="https://i.stack.imgur.com/otnBJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/otnBJ.png" alt="enter image description here"></a></p>
  
  <p>... where CCY is the currency column I would like within the pivot table and not as a pivot row or column label.</p>
  
  <p>/ Phillip</p>