5 Replies Latest reply on Aug 6, 2018 10:08 PM by Tushar More

    Analysing ONLY rows with certain values, under a particular dimension?

    Jinjia Lin

      I have a data source with the following columns:

       

      Gender, Name, Favourite Sport

       

      I want to calculate the different sums of people who like particular sports, but only for a certain gender in a particular instance, through a parameter control for users to interact with.

       

      How do I filter the rows based on gender first, then proceed to count the number of people who favour a particular sport? I tried to create a parameter with Male/Female as the values and then building a calculated field:

       

      Case [Gender]

      when 'Male' then ...

      when 'Female' then ...

       

      but I have no inkling on the functions that I should use. Is it lookup?

       

      I am hoping for my end result on the Worksheet/Dashboard to look something like this:

       

      Table 1: Favourite Sport of Males

       

      SportCount
      Soccer3
      Tennis 5
      Basketball10
      Rugby3

       

      And then a separate "Table 2" for Females when I toggle the gender parameter accordingly.

       

      Thanks in advance for the help!