3 Replies Latest reply on Sep 26, 2017 2:08 PM by Hari Ankem

    Create 3 dimensions from 1 (Tableau 9.3)

    Kristin Fitzpatrick

      This seems like a simple thing to do, but I'm stumped.

      I have a dimension that is broken into two categories, "Center" and "Affiliate." Combined (each Center plus its Affiliates), they make up a "Network" dimension that I want to create.

      Then I want to show Monitoring Visits by Center, Affiliate, and Network totals.

      I've tried a few different calcs using LOD or a parameter, but I can't make it work. Maybe using the dual axis to display different years is constraining the solution - not sure.

      The attached workbook shows the current problem, the desired solution, and lists a specific forum post I've tried.

      Any help much appreciated!