3 Replies Latest reply on Jan 9, 2019 12:26 PM by Joshua Preston

    Sort by % of total LOD with 2+ dimensions

    Joshua Preston

      I tried to replicate this solution Sort by % of total table calc that Paul Wachtler successfully solved.

      This new scenario has three dimensions instead of two. I tried a number of sort options, but the logic is tricky since there are more dimension combinations/measures.

      I'd ideally like to have the sort cascade like the screen shot showing Free, Partially Free, and Not Free (in that order) all on one sheet.

       

      the following are partial solutions. Workbook attached (Dashboard 2). thx in advance.