Spreadsheet: 604323d1546517271-need-help-with-separating-data-on-a-pivot-report-book3
Sheet: Data

Category | Type | Month | Unit | Cost | Quantity | Total Cost | Tariff Basis | Tariff Amount | Tariff Rate | Total Tariff | Assumption
Beef | Calves | 2019-04-01 00:00:00 | Head | 10 | 2000 |  | Weight (kg) | 5 kg | 12 | 5000 | Unable to sell stock
Beef | Calves | 2019-04-01 00:00:00 | Head | 10 | 2000 |  | Weight (kg) | 5 kg | 12 | 5000 | Unable to transport stock
Beef | Calves | 2019-04-01 00:00:00 | Head | 10 | 2000 |  | Weight (kg) | 5 kg | 12 | 5000 | Assumption 7
Beef | Calves | 2019-05-01 00:00:00 | Head | 11 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Unable to sell stock
Beef | Calves | 2019-05-01 00:00:00 | Head | 11 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Unable to transport stock
Beef | Calves | 2019-05-01 00:00:00 | Head | 11 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Compensation Scheme
Beef | Calves | 2019-06-01 00:00:00 | Head | 12 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | New buyer for stock
Beef | Calves | 2019-06-01 00:00:00 | Head | 12 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 5
Beef | Calves | 2019-06-01 00:00:00 | Head | 12 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 7
Beef | Calves | 2019-07-01 00:00:00 | Head | 13 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Unable to sell stock
Beef | Calves | 2019-07-01 00:00:00 | Head | 13 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Unable to transport stock
Beef | Calves | 2019-07-01 00:00:00 | Head | 13 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 7
Beef | Calves | 2019-08-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Compensation Scheme
Beef | Calves | 2019-08-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 5
Beef | Calves | 2019-08-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 7
Beef | Calves | 2019-08-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 12
Beef | Calves | 2019-09-01 00:00:00 | Head | 15 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Compensation Scheme
Beef | Calves | 2019-09-01 00:00:00 | Head | 15 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 5
Beef | Calves | 2019-09-01 00:00:00 | Head | 15 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 6
Beef | Calves | 2019-10-01 00:00:00 | Head | 16 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 7
Beef | Calves | 2019-10-01 00:00:00 | Head | 16 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 11
Beef | Calves | 2019-10-01 00:00:00 | Head | 16 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 16
Beef | Calves | 2019-11-01 00:00:00 | Head | 17 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Unable to sell stock
Beef | Calves | 2019-11-01 00:00:00 | Head | 18 | 2001 |  | Weight (kg) | 51 kg | 12 | 5000 | Unable to transport stock
Beef | Calves | 2019-11-01 00:00:00 | Head | 19 | 2002 |  | Weight (kg) | 52 kg | 12 | 5000 | Assumption 11
Beef | Calves | 2019-12-01 00:00:00 | Head | 16 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 13
Beef | Calves | 2019-12-01 00:00:00 | Head | 16 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 17
Beef | Calves | 2019-12-01 00:00:00 | Head | 16 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Compensation Scheme
Beef | Calves | 2020-01-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Unable to sell stock
Beef | Calves | 2020-01-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 10
Beef | Calves | 2020-01-01 00:00:00 | Head | 14 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 15
Beef | Calves | 2020-02-01 00:00:00 | Head | 12 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Unable to transport stock
Beef | Calves | 2020-02-01 00:00:00 | Head | 12 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 8
Beef | Calves | 2020-02-01 00:00:00 | Head | 12 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Assumption 9
Beef | Calves | 2020-03-01 00:00:00 | Head | 11 | 2000 |  | Weight (kg) | 50 kg | 12 | 5000 | Compensation Scheme
Beef | Calves | 2020-04-01 00:00:00 | Head | 12 | 2001 |  | Weight (kg) | 51 kg | 12 | 5000 | Assumption 5
Beef | Calves | 2020-05-01 00:00:00 | Head | 13 | 2002 |  | Weight (kg) | 52 kg | 12 | 5000 | Assumption 8
Dairy | Milk | 2019-04-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Unable to sell stock
Dairy | Milk | 2019-04-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 9
Dairy | Milk | 2019-05-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Unable to sell stock
Dairy | Milk | 2019-05-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 8
Dairy | Milk | 2019-05-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 6
Dairy | Milk | 2019-05-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 14
Dairy | Milk | 2019-06-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 8
Dairy | Milk | 2019-06-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 16
Dairy | Milk | 2019-06-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 18
Dairy | Milk | 2019-07-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Unable to transport stock
Dairy | Milk | 2019-07-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 16
Dairy | Milk | 2019-08-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 14
Dairy | Milk | 2019-09-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 9
Dairy | Milk | 2019-10-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | New buyer for stock
Dairy | Milk | 2019-11-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Unable to transport stock
Dairy | Milk | 2019-12-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Unable to transport stock
Dairy | Milk | 2020-01-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 11
Dairy | Milk | 2020-02-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 9
Dairy | Milk | 2020-03-01 00:00:00 | Litre | 0.28 | 10000 |  | Fat Content | 3%-6% | 0.2 | 8000 | Assumption 13