Subsets: Which customers in customer group 2 bought more than 9 units of any single product?

    Subsets: Which customers in customer group 2 bought more than 9 units of any single product?

    Hello again,

    How can I create a subset in Jedox which can answer the following question based on the cube shown in the image?

    Which customers in CustGroup2 bought more than 9 units of any single product during the year?


    I can't seem to phrase this question in the Subset Editor. Any suggestions are greatly appreciated.

    Also is there any place where I can use MDX?

    Many thanks

    Kavee
    Images
    • JedoxSubsetQuestion.jpg

      125.11 kB, 659×430, viewed 95 times