Forum Discussion
ryanyeh1123
2 years agoFrequent Visitor
Move the customized subtotal to the left side
Hello, I have a problem to move my subtotal customized FPYR % to the left side. (The red frame in the picture.) I have already change the caculation of subtotal FPYR % currently. Replace the origin...
- 2 years ago
Hi ryanyeh1123
Try these tutorials maybe they will help :
https://www.youtube.com/watch?v=VRUs0pWgsdEhttps://www.youtube.com/watch?v=ExCD0vM-OEU
for more specific suggestions :
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
ryanyeh1123
2 years agoFrequent Visitor
What I want to be is as below.
| Stage | Customize SubTotal | NR. FLB Test | N2.FCT-1 | ||||
| Unit P/N | Overall FPYR % | FPYR % | Defect Q'ty | Input Q'ty | FPYR % | Defect Q'ty | Input Q'ty |
| 1 | 74.86% (=90.91%*82.35%) | 90.91% | 1 | 11 | 82.35% | 3 | 17 |
| 2 | 87.68% (=96.38%*90.97%) | 96.38% | 5 | 138 | 90.97% | 13 | 144 |
| 3 | 94.13% (=98.44%*95.62%) | 98.44% | 26 | 1667 | 95.62% | 73 | 1665 |
| 4 | 0% | 0% | 1 | 1 | 100% | 0 | 2 |
| Total | 93.40% (=98.18%*95.13%) | 98.18% | 33 | 1817 | 95.13% | 89 | 1828 |