Visokio website     Downloads     Video tutorials     KnowledgeBase  
Pivot View: Pivoting by more than two categories? - Visokio Forums
Pivot View: Pivoting by more than two categories?
  •        benjamin June 9, 2014 12:14PM

    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]


    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.
  •     tjbate June 9, 2014 1:52PM

    You can change the order in which the pivoting/aggregations are performed by dragging [Tier] upwards to make it the first field pivoted/aggregated...

    See example
  •        benjamin June 10, 2014 3:50AM

    Thanks , tjbate

    However that does not help, the ordering is very important when producing double pivots,

    Can you provide a fix or upgrade so that the second pivot behaves as one would expect, or move this to an idea


  •     paola June 11, 2014 12:08PM
    UPDATE: actually you can enable this option, in both Desktop and Mobile version by ticking :
    Pivot View Tools > Other > Empty data buckets > Always / Show empty data buckets
  •        benjamin June 11, 2014 12:21PM
    that solves it , thanks
This discussion has been closed.
← All Discussions


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership