2 Replies Latest reply on Aug 10, 2018 9:57 AM by Molly Zechar

    Set Dimensions Side-by-Side without Subsetting?

    Molly Zechar

      I have 4 status dimensions each with an associated ID (count) and revenue (sum). Is there a way to get all 4 dimensions (with their ID counts and sums of revenue) into a single table so that there is a single row per client without them appearing as subsets of each other? I can set them side-by-side in a dashboard, but because the client list is long you have to scroll down on all four tables to line up a single row.


      The attached workbook contains a simplified dataset to illustrate my question.


      I realize that there appear to be duplicated rows in the data. I am looking into it, but I suspect part of that is because the rows differ on one of the two dimensions not included in the sample.