1 Reply Latest reply on Aug 10, 2018 1:15 AM by Sankarmagesh Rajan

    combining different level of aggregation into one worksheet

    Christian Go

      I have below sample data:

       

      ====================================================

        

      dim1dim2measure1
      Open LateOpen423
      Open OntimeOpen21
      Closed LateClosed223
      Closed OntimeClosed112

       

       

      ====================================================

       

       

      I would want to create just one worksheet for below::

       

       

       

      Is this possible? I already have a visualization like above but it's using 3 worksheets.

      As the dashboard is really slow, I want to combine what similar worksheets as much as possible.

       

      I tried adding a continuous 'dummy' measures on the Row shelf, but it's copying all the granularity across all rows.

       

       

       

      Thanks!