3 Replies Latest reply on Apr 4, 2016 12:28 AM by Mahfooj Khan

    TOP 5 of 6 Dimensions at a time on a single view??

    Rakesh Behera

      How to get TOP 5 of 6 Dimensions at a time on a single view???

        • 1. Re: TOP 5 of 6 Dimensions at a time on a single view??
          Mahfooj Khan

          Hi,

          Using sets your can achieve this.

          Create a integer parameter first.

          Create sets for respective dimensions using the created parameter.

           

          Here I've created Top Customers based on sales.

          Once done with your sets.

          Right click on the parameter and Show Parameter Control

          Drag your dimension in row shelf then drag the respective sets in filter shelf.

           

          In the similar fashion your can create your sheets for respective sets.

          Then create a dashboard drag your sheets. If you change the parameter value then it will reflect in all other sheets.

           

          I hope this will help you to get some idea.

          Feel free to ask if you have any query.

           

          Mahfooj

          1 of 1 people found this helpful
          • 2. Re: TOP 5 of 6 Dimensions at a time on a single view??
            Rakesh Behera

            Hi,

                Thx a lot for ur response.. I got the TOP5 of all Dimensions individually.. but how to get TOP5 of all in a single view....

              { I am putting all the Dimensions in Row Self,, Then trying to change the values in the Parameter..} .. is it right???

            Plzz   rectify me...........?

            • 3. Re: TOP 5 of 6 Dimensions at a time on a single view??
              Mahfooj Khan

              No, in a single worksheet you wont get that view of Top5 for individual dimensions.

              Let assume your dimensions are State, Customer Segment, Customer Name, Product Name ad so on.

              Once you filter your Top5 on State it will show only for Top5 States and the corresponding records from rest of the dimensions. You just need to create different sheets for each dimensions. Then put it in a single dashboard which is also is your single view. Hope you got my point.