3 Replies Latest reply on Feb 13, 2018 3:39 AM by Sankarmagesh Rajan

    Action  on grand total

    Roisha Pal

      Hi Guys,

       

      In the attached workbook, if i click on Total on 2013 like below(322) it should direct me detail sheet with all the detail fields amount. Also the detail sheet should be hidden first and should be activated on clicking n any chart total only

        • 1. Re: Action  on grand total
          Sankarmagesh Rajan

          Hi Roisha,

           

          grand Total will not work as filter in action.

          Better try with union all and added total and try.

           

          create query as

          SELECT [Orders$].[Category] AS [Category],

              [Orders$].[Order Date] AS [Order Date],

              [Orders$].[Profit] AS [Profit],

            [Orders$].[Sales] AS [Sales],

          'Data' as [Alias]

          FROM [Orders$]

          union All

          SELECT [Orders$].[Category] AS [Category],

              [Orders$].[Order Date] AS [Order Date],

            [Orders$].[Profit] AS [Profit],

              [Orders$].[Sales] AS [Sales],

          'Total' as [Alias]

          FROM [Orders$]

           

          Go to worksheet and create calc as

          if [Alias]='Data' then [Category]

          else 'Total'

          END

           

          Drag this calc into row or column.

          Drag sales into text.

           

          Now set actions as below

           

          First drag vertical container into dashboard and drag your sheets one by one.

          Set actions and get it.

           

          Thanks

          sankar

          • 2. Re: Action  on grand total
            Roisha Pal

            Thanks a lot Sankar, it helped me. But how can i hide the detail sheet first time and activate it after clicking on summary tab any chart?

            • 3. Re: Action  on grand total
              Sankarmagesh Rajan

              Hi

               

              once sheets added then click total and and get the details chart. once click outside then it will clear action and sheet will hide.

               

              thanks

              sankar