I've attach a simple excel file and am trying to figure out how to do the same think with a connection only setup
Hi Bill,
It looks like you didn't click the 'Start Upload' button after choosing the file you wanted to share. Can you please upload it again. It's a 2 step process:
1. Click the 'Add files' button and select the files you want to upload
2. Click the 'Start Upload' button.
Thanks,
Mynda
Opps ... I've attached the file
Hi Bill,
Yes, you can. See example attached.
You have to add another table containing the acres for each LOMPOC and then merge those tables together (session 3.04). Then add a custom column (session 4.14) to calculate the cost per acre. You can then summarise the query in a PivotTable.
Note: your totals in row 20 don't reconcile to the figures above which is why the PivotTable Grand Total row is different to yours.
Kind regards,
Mynda
