Hi all, quite new to pivot tables. But am coming to realise the power. My question, the table that my pivot table uses as it's data source has daily sale data for advisers. But while I can create a pivot table showing weekly sales summary their targets are weekly and not entered in source data table. How can I show weekly sales vs weekly target performance in a single pivot table if target data elsewhere?
any suggestions or references much appreciated.