6 Replies Latest reply: Oct 4, 2013 2:08 AM by Ferha Sharma RSS

    Addition of rows in a straight table

    Ferha Sharma

      Hello Everyone,

       

      I have an issue ,i want to create a table in which i want to add values for a row in which i get the total of all the above rows ,eg i have 10 products and then i want to have there total in the 11 row then again i have 5 products and then the total of these 5 rows only ot should not have above 10 values sum.How can i do this.

       

      Thanks in advance

      Ferha Jafri

        • Re: Addition of rows in a straight table
          Tresesco B

          Use pivot table and enable sub total in the presentation tab.

            • Re: Addition of rows in a straight table
              Ferha Sharma

              I cannot use pivot table as i am creating a inline table as per user requirement the scenario is like we have product name which comes under product grouping which comes under SBU wich comes under Division and then sub division,so client want to show this hierarchy in pivot table but in one column so i thoght to create an inline table and mention there product code along withe the products but the problem is the sum how to get the sum of all the products which fall under one sub division....

                • Re: Addition of rows in a straight table
                  Aadil M

                  Can you post a sample QVW...

                    • Re: Addition of rows in a straight table
                      Ferha Sharma

                      I cannot attach the qvw but can explain the scenario in detail

                       

                      . The issue is like the client wants a report in which they want to view the hierarchy horizontally in pivot table .As far as my knowledge says that we can do this by creating an inline table with  if then else statements but in this case the no. of rows are 1,117 so these many if ,else needs to be there and if I create an excel with this order and take product code or product id to map this table then there are many fields that do not have product id and they also want to view the total at Sub division level.

                       

                      Eg

                       

                      P1

                      P2

                      P3

                      PG1

                      PG2

                      PG3

                      SUB1

                      SUB2

                      SUB3

                      DIV1

                      DIV2

                      DIV3

                      SUBDIV1

                      SUBDIV2

                      SUBDIV3

                       

                        Here p1 is product name,pg1 is the product group,sub1 is the sub,div1 is the division ,subdiv1 is the subdivision ,this the  hierarchy which user wants in the report .

                • Re: Addition of rows in a straight table
                  Greg Anderson

                  There are multiple ways to do it, but the easiest way for me would be the creation of three (or more) new fields for the sum:

                   

                  Newfield_1 contains the cumulative sum for Group 1 (WHERE Division IN (First set of values)).

                  Newfield_2 contains the cumulative sum for Group 2 (WHERE Division IN (Second set of values)).

                  Newfield_Summary adds Group 1 to Group 2 for each row, so it always contains the relevant total.

                   

                  If you do this is script, you could drop the "Newfield_n" fields after loading.

                   

                  During development, keeping them might be useful to verify totals and make sure it's working correctly.

                    • Re: Addition of rows in a straight table
                      Ferha Sharma

                      But for the specific order i have to create an inline table as the view should have

                      product name which falls under one particular product grouping and then comes then SUB which contains the above values then sub division and then then division comes which contains above values and the same sequence repeats again so it is like they want to view an hierarchy which we can show the through pivot table in a singe column.