http://forums.visokio.com/discussions/tagged/empty_data_buckets/feed.rss Mon, 30 Oct 17 17:04:35 -0400 Tagged with empty_data_buckets - Visokio Forums en-CA http://forums.visokio.com/discussion/2585/pivot-view-pivoting-by-more-than-two-categoriess Mon, 09 Jun 2014 12:14:43 -0400 benjamin 2585@/discussions
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.]]>