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

How to make total result by dimensions

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.

Defect A25
Part BDefect A110
Defect A27
TotalDefect A114
Defect A212
• 1. Re: How to make total result by dimensions

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

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

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

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

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

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

Hello Duong,

How do you calculate "defect rate" ?

 Heat 1 Heat 2 defect rate A C1 0.1 C2 0.8 B C1 0.7 C2 0.9 Total C1 0.6

Regards.

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

Hi Chen

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

Thank.

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

Hello Duong,

I assume,

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

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

HI Ms. Lei

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

Hello Duong,

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

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

HI Ms. Chen