Share
Report
207Hi Experts ,
I am working on an excel file having 330k rows and i want to optimize with some filters.
Below the sample input and output i want to work on.
Data source : Sharepoint folder - .xlsx files only (its a monthly file so every file has a mon-yyyy in the file names)
INPUT :
| Country | SBU | Grade | Status |
| US | AA | A | Completed |
| US | AA | B | Completed |
| US | AA | B | Completed |
| US | AA | C | Completed |
| US | AA | B | Completed |
| UK | BB | B | Completed |
| UK | BB | B | Overdue |
| UK | BB | B | Completed |
| UK | BB | C | Overdue |
| UK | BB | B | Overdue |
OUTPUT :
| Country | SBU | Grade | % | Completed Status |
Total Status |
| US | AA | B | 100.00% | 3 | 3 |
| UK | BB | B | 50.00% | 2 | 4 |
Requirement is to filter Grade B from the above table and count the completed status and calculate % group by Country & SBU.
Please help to give idea on creating a flow .
Please help to give idea on creating a flow .
Thanks
DK
Categories:
I have the same question (0)
All responses (
Answers (
