4 Replies Latest reply: Jun 14, 2017 6:36 AM by kushal chawda RSS

    Display count of Subsectors which acquires 80% of the Market in a Text object

    Zain Shaikh

      Hi Everyone,

       

      I want to display the count of Subsectors acquiring 80% of the Market in a text object.

       

      There's a unique id which defines the Market Size for e.g., Id=6. If i use this in a set expression, it gives me the market size values corresponding to the respective sub sectors.

      Dimension- [Sub Sectors]

      Set Expression: Sum({$<Id={6}, Year={2017}>}[Market Size Values])    (for the current year). This gives me the result as shown in the below table:

       

      Sub Sectors Market Size Values
      Sub Sec11000
      Sub Sec22000
      Sub Sec33000
      Sub Sec44000
      Sub Sec55000

       

      But, if i've to display the count of subsectors which acquires 80% of the Market in a text object, how can we achieve this? Please advise.

       

      Thanks,

      Zain Shaikh