4 Replies Latest reply on Jul 16, 2018 7:08 AM by Céline KROPP

    Total of a TOP10 ranking?

    Céline KROPP

      Hello everybody,

       

      My question is quite simple, is it possible to have a total of a TOP 10 ranking and how?

      My table only shows TOP 10 values out of more than 400 values.

      The thing is that when i put the total under the table, it is the global total and not the total for my TOP10.

       

      Thanks in advance for your help

       

      Have a nice day!

       

      Céline

        • 1. Re: Total of a TOP10 ranking?
          Naveen B

          Hi Celine,

           

          I am getting the correct in order to get the what is the approach you are following it seems you will be using table calculation like index , first or last or rank with use of table calcs your grand total wont be affected.

           

          If you are the table calculation then it must be you have more than 1 filter in the filter pane what you need to do add the filters to context and then apply the top 10 filter on the dimension so that you will get the correct value

          1 of 1 people found this helpful
          • 2. Re: Total of a TOP10 ranking?
            Céline KROPP

            Hi Naveen and thanks for your support!

             

            Unfortunately I have troubles with your solution, because many filters are already applied to my table.

            And when I try to filter like you show me, there is nothing...

            But without my filters it works, but they are necessary to my analysis...

             

            Thanks for your help!

             

            Have a nice day

             

            Céline

            • 3. Re: Total of a TOP10 ranking?
              Naveen B

              Hi Celine ,

               

              apart from top 10 filter , what are the filters you have you can add them to context so that based on order of operations first context filters will get applied.

               

              Is there any possibility mock-up the problem with superstore data-set so that it will be easy to debug 

              1 of 1 people found this helpful
              • 4. Re: Total of a TOP10 ranking?
                Céline KROPP

                Hi Naveen,

                 

                Wow I didn't know this context function!

                Thanks a lot for your support

                 

                Céline