6 Replies Latest reply on Aug 29, 2017 3:23 AM by Sandeep Das

    BAR Chart with "All" value

    karthik Valluri

      Hi All,

       

      I have the below requirement where the customer wants to have a BAR with all values of the dimension. My dimension currently has 3 values A,B and C. However i need

      the ALL value to come up too. For eg:- If the user selects C bar then the All bar show reflect value 600 too. ( output shown in excel)

       

      After trying a lot i finally added 2 sheets and used actions in my dashboard....although i get the same output i would want to check if there is a way of doing it in a single chart itself.

      Thanks in advance.

       

        • 1. Re: BAR Chart with "All" value
          Sandeep Das

          Hi Karthik,

           

          Hopefully this is what you want!!

           

           

          Thanks

          Sandeep

          1 of 1 people found this helpful
          • 2. Re: BAR Chart with "All" value
            Mahfooj Khan

            Hi Kartik,

             

            I guess you required help from LOD{} in this scenario.

            For All you may try this calculation

            {SUM(Value)} //This will always returns the total value until you don't use any context filter on any dimension in your view.

            Give a try and let us know if this help.

             

            Another way using parameter.

             

            Mahfooj

            • 3. Re: BAR Chart with "All" value
              T G

              Hello Karthik,

               

              I think Sandeep's solution is the simplest one. Still, you need to update the test of Grand Total on axis. Just right click on axis and select format. Change the text in Label text box.

               

               

              TG

              • 4. Re: BAR Chart with "All" value
                Sankarmagesh Rajan

                Hi Karthik

                 

                Create query as

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

                  [Orders].[OrderDate] AS [OrderDate],

                  [Orders].[OrderID] AS [OrderID],

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

                  [Orders].[Quantity] AS [Quantity],

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

                  [Orders].[Segment] AS [Segment],

                  [Orders].[SubCategory] AS [SubCategory],

                'Data' as [Data]

                FROM [dbo].[Orders] [Orders]

                Union All

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

                  [Orders].[OrderDate] AS [OrderDate],

                  [Orders].[OrderID] AS [OrderID],

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

                  [Orders].[Quantity] AS [Quantity],

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

                  [Orders].[Segment] AS [Segment],

                  [Orders].[SubCategory] AS [SubCategory],

                'All' as [Data]

                FROM [dbo].[Orders] [Orders]

                 

                Create Calculation as

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

                else 'All'

                END

                 

                Drag this calc into row and sales into column.

                 

                 

                 

                Thanks

                sankar

                • 5. Re: BAR Chart with "All" value
                  karthik Valluri

                  Thank you guys...Sandeep's solution helps..but my main intention was to achieve drill through in the "All" bar in case the user selects to drill-through the "All" bar ( for that reason i used actions) instead of individual bars.

                  • 6. Re: BAR Chart with "All" value
                    Sandeep Das

                    Yes for drill through thats right way to do.

                     

                    If my reply helped you to solve your query then please mark my reply as answered one.

                     

                    Thanks

                    Sandeep