VP_Test.xlsx
Missing file
Can you tell me the inventory on hand by client and Class
Client
and Class
.Client
and Class
:Client | Class | On Hand |
---|---|---|
Altair | Key Card | 19000.0000 |
Altair | Umbrella | 350.0000 |
Biltmore | Key Card | 82000.0000 |
Courtyard Inn | Key Card | 17000.0000 |
Hotel Saint | Body Lotion | 231.0000 |
Hotel Saint | Body Wash | 270.0000 |
Hotel Saint | Conditioner | 279.0000 |
Margaritaville Times Square | Key Card | 15000.0000 |
Marriott Bonvoy | Key Card | 30000.0000 |
Mosaic | Key Card | 8000.0000 |
Mosaic | Luggage Tag | 14000.0000 |
Renaissance Honolulu | Umbrella | 200.0000 |
Smyth | Luggage Tag | 8000.0000 |
The Elser | Key Card | 80000.0000 |
The Gates | Key Card | 12000.0000 |
The Gregorian | Key Card | 9000.0000 |
The Joseph | Key Card | 40000.0000 |
The Newbury | Key Card | 21070.0000 |
Viceroy | Key Card | 168000.0000 |
Viceroy | Luggage Tag | 15000.0000 |
x | Body Lotion | 397148.5000 |
x | Body Wash | 94361.0000 |
x | Candle | 12.0000 |
x | Conditioner | 105823.6216 |
x | Hand Wash | 34848.0000 |
x | Key Card | 74000.0000 |
x | Luggage Tag | 28000.0000 |
x | Restaurant | 3606.0000 |
x | Shampoo | 105002.8128 |
x | Umbrella | 500.0000 |