14 Replies Latest reply on Aug 12, 2016 4:13 AM by Duong Vu

    How to make total result by dimensions

    Duong Vu

      Dear all.

      I must make report as same like below

      I can make for Part A & Part B result total

      but make same below, I can't

      Everybody can help me.

      thank so much.

       

      Header 1Header 2Q 'ty
      Part ADefect A14
      Defect A25
      Part BDefect A110
      Defect A27
      TotalDefect A114
      Defect A212
        • 1. Re: How to make total result by dimensions
          lei.chen.0

          Hello Duong,

           

          Usually subtotal is recommended for subtotals by dimension, which appear at the end of each dimension.

           

          In your case, subtotals by dimension is required to appear at the end of the view, thus, a little more hand work is necessary.

          Please refer to the attached workbook for details.

           

          Regards.

          • 2. Re: How to make total result by dimensions
            Duong Vu

            hi Mr. Lei

            how can I make same you exam ?

            can you guide me ? I can't see your attach file.

            • 3. Re: How to make total result by dimensions
              lei.chen.0

              Hello Duong,

               

              Here are the steps,

               

              1. make a calculation field [Part A] IIF([Header1]="Part A",[Qty],0)

              2. make a calculation field [Part B] IIF([Header1]="Part B",[Qty],0)

              3. make a calculation field [Total] [Qty]

              4. place them onto the shelves as below.

               

              By the way, the attached workbook can be found here,

               

              Regards

              • 4. Re: How to make total result by dimensions
                Duong Vu

                Dear Mr. Lei Chen

                thank so much, it is very helpful for me.

                 

                if possible I want to open my report .

                before I have issue how to calculate defect rate, for Defect A1, defect A2 ( header 2), => total defect Header 1

                and make calculate total by Header 2 , calculate defect rate.

                first I think is same my question, but when I apply, it is difference.

                Can you help me more ? ^^

                 

                thank so much.

                • 5. Re: How to make total result by dimensions
                  lei.chen.0

                  Hello Duong,

                   

                  Not sure if I've understood your requirements well.

                  Do you mean this?

                   

                   

                  Regards

                  1 of 1 people found this helpful
                  • 6. Re: How to make total result by dimensions
                    Duong Vu

                    dear Mr. Lei chen

                    thank so much.

                    I mean result is same before.

                    this is my issue :

                    first : I have quantity product for daily & detail defect for daily.

                    I must calculate defect rate by section for daily & monthly, I also make joined & blend 2 source,

                    so output result :

                    Heat 1     Heat 2     defect rate

                    A               C1          0.1                    / I already finish

                                     C2          0.8                        / I already finish

                    B               C1          0.7                         / I already finish

                                     C2          0.9                         / I already finish

                    Total         C1          0.6                         / Not yet

                                      C2         0.8                         / Not yet

                    • 7. Re: How to make total result by dimensions
                      lei.chen.0

                      Hello Duong,

                       

                      How do you calculate "defect rate" ?

                       

                      Heat 1Heat 2defect rate
                      A C10.1
                      C20.8
                      B C10.7
                      C20.9
                      Total C10.6

                       

                       

                      Regards.

                      • 8. Re: How to make total result by dimensions
                        Duong Vu

                        Hi Chen

                        - defect rate = defect Q'ty ( for Heat) / product Q'ty ( total)

                         

                        Thank.

                        • 9. Re: How to make total result by dimensions
                          lei.chen.0

                          Hello Duong,

                           

                          In your original sample data, there are three fields, Header1, Header2 and Q'ty

                           

                          I assume,

                          Header1 = Heat1

                          Header2 = Heat2

                           

                          But how about Qty? Does it stand for defect Q'ty or product Q'ty?

                          If Q'ty is defect Q'ty, where can I get product Q'ty? Is it a field in your data or a calculated field?

                           

                           

                          Regards

                          • 10. Re: How to make total result by dimensions
                            Duong Vu

                            hi, Mr. Lei

                            Quantity prod you can fit 1 unit, depend on u.

                            And, do you have email, I will share my data to you.

                             

                            thank so much.

                            • 11. Re: How to make total result by dimensions
                              Duong Vu

                              HI Ms. Lei

                              I already follow ur guide, about calculate for defect rate, ur method still correct.

                              thank so muc.

                              but sorry not ask u begin, because I already bending & join my raw data.

                              so that when I apply ur method, it will be error ( can't use 2 source data)

                               

                              but thank so much, your support.

                              • 12. Re: How to make total result by dimensions
                                lei.chen.0

                                Hello Duong,

                                 

                                Sorry for my late reply.

                                 

                                Four fields have been mentioned in the previous discussion,

                                 

                                Heat 1

                                Heat 2

                                Q'ty ( for Heat)

                                Product Q'ty ( total)

                                 

                                And it seems you have two data sources.

                                May I know which fields are in which data source?

                                 

                                For example,

                                Data source 1: Heat 1, Heat 2, Q'ty (for Heat)

                                Data source 2: Product Q'ty (Total)

                                 

                                 

                                Regards

                                • 13. Re: How to make total result by dimensions
                                  Duong Vu

                                  Dear Ms. Chen

                                  it is difficult to say,

                                  I have 1 raw data for daily quantity product

                                  Date     Q'ty

                                  1/1/16   1000

                                  1/2/16   5000

                                   

                                  1 raw data for defect defect by daily

                                  Date        Tool           Type          Q'ty

                                  1/1/16        AA              Defect A     2

                                  1/1/16        BB              Defect B     1

                                  1/2/16        AA              Defect C    1

                                  1/3/16       BB               Defect A    4

                                   

                                  Request : make result

                                   

                                  Tool                  Type           date     defect rate

                                  AA                  Defect A      1/1/16         (2+4)/1000

                                  AA                  Defect B      1/1/16          1/1000

                                  BB                  Defect A                       ............

                                  BB                  Defect B ..........................................

                                  Total               Defect A .......................................

                                                         Defect B ......................................

                                   

                                  Sorry can't up any file attach, because my computer was block.

                                   

                                  thank.

                                  • 14. Re: How to make total result by dimensions
                                    Duong Vu

                                    HI Ms. Chen

                                    I already finish , ^^ base on your guide.

                                     

                                    thank so much.