Forum Discussion
jackypatel
Helper I
3 years agoUnique date wise unique Product Count
Hi...... My Database name is "PDI DATA"& i required Unique date wise unique names count. E.g. 27-03-2021 has "HM-12.5A-LM-ACC-NS" count is 1 & 27-03-2021 has "12.5C-FDB-ACC" also count is 1. And at ...
- 3 years ago
PowerPivot is crashing on my system so i cannot frame this solution in MS Excel.
jackypatel
Helper I
2 years agoSir, Thanx for the Help. In addition to that need counting of accepted Lot.
Example-
My Database name is "PDI DATA"& i required Unique date wise unique names count & Accepted, rejected Count too. E.g. 27-03-2021 has "HM-12.5A-LM-ACC-NS" count is 1 and Accepted Count 1 & 27-03-2021 has "12.5C-FDB-ACC" also count is 1and Accepted Count 1. And at the end i need Grand total of counts
| Inspection Date | Product | Result |
| 27-03-2021 | HM-12.5A-LM-ACC-NS | Accepted |
| 27-03-2021 | HM-12.5B-LM-ACC-NS | Accepted |
| 27-03-2021 | 12.5C-FDB-ACC | Accepted |
| 27-03-2021 | LTT8-20 | Accepted |
| 25-03-2021 | CLR400000-A2 | Rejected |
| 26-03-2021 | LD200686-E2 | Accepted |
| 26-03-2021 | LD200686-E2 | Accepted |
| 26-03-2021 | LD200686-E2 | Accepted |
| 26-03-2021 | LD200686-E2 | Accepted |
| 25-03-2021 | LDRR24-CDL | Rejected |
| 25-03-2021 | LDRR24-CDL | Rejected |
| 25-03-2021 | LL725003-D1 | Accepted |
| 25-03-2021 | LL725003-D1 | Accepted |
| 25-03-2021 | LL725003-D1 | Accepted |
| 25-03-2021 | LL725003-D1 | Accepted |
| 25-03-2021 | LL725003-D1 | Accepted |
| 25-03-2021 | LL725003-D1 | Accepted |
| 25-03-2021 | LL725003-D1 | Accepted |
| 25-03-2021 | LDLRC-20PRO-CDL | Accepted |
| 25-03-2021 | LT8-20-865-2 | Accepted |
| 25-03-2021 | LT8-20-865-2 | Accepted |
| 25-03-2021 | LT8-20-865-2 | Accepted |
| 25-03-2021 | LT8-20-865-2 | Accepted |
| 25-03-2021 | LT8-20-865-2 | Accepted |
| 25-03-2021 | LT8-20-865-2 | Accepted |
| 25-03-2021 | LT8-20-865-2 | Accepted |