20 Replies Latest reply: Aug 28, 2014 2:53 AM by Nikhil Garg RSS


    Nikhil Garg


      I have a Disaster Data having following Dimensions:


      Disaster.Year , Disaster.Type , Disaster.Killed(Total Killed People for particular disaster) , StateData.Killed(Statewise killed people for particular disaster) , StateData.Location.


      I want to create a bar chart showing the total killed people for different disasters in increasing order. i.e Total killed people by disaster1 , then disaster2 and so on.


      I am using following set analysis but it is not giving me ryt output. Please solve the issue....


      Sum({$<Disaster.Type = {"=rank(Sum(Disaster.Killed),4)<= 10"} > }Disaster.Killed)