Hi

I am pivoting by two (2) fields horizontally e.g. [Field 1] , which contains A1, A2 and [Field 2] which contains B1,B2

[Field 1] [Field2]

  A1
            B1
            B2
  A2
            B1
            B2

My problem is that if in the data there is no row which has A2 in [Field 1] and B2 in [Field 2], in the Pivot View it will leave the associated rows empty with no row header or anything.
See example... most probably more clear.
For the Collateralised, Senior Unsecured and Supranational bonds they have only Tier *, however below Tier * there are gaps where Omniscope thinks other examples of tiers should go.