4 Replies Latest reply on Aug 17, 2018 7:01 AM by Okechukwu Ossai

    Dynamic Sets Question

    Ben Peterson

      The attached workbook has a matrix that shows the number of members in each of 10 categories (gray). Also shown is the number of members in each intersection of categories (orange).

      Dashboard 1.png

      Thought I would experiment with dynamic sets to get the same values. The bar chart on the left uses Category Name Parameter 1 and is filtered by Set Category Name 1...no problem, I get the same values as in the gray.

      Capture2.PNG

      However, when I try to use two parameter and a combined set to filter the data, I can't get the values in the orange...am I missing something?

      Capture.PNG

      Ben