Pivot table controlled by slicer from disconnected table

Hi,
I have a pivot table controlled by a slicer made from a disconted table, it works, as long as a vlue is selected, but if not values are slected the table is filtered down to no rows.

Please Login or Register  to view this content.

What I've been trying to do is add an if statemen so that if nothing is selected I get back the totals, I'd like the filtered totals but would settle for an overall total at the moment.
I've tried

Please Login or Register  to view this content.

which gives the correct grand total for the selection, but isn't right, I've attached a workbook with both ,
so when no slicer used I'd like 'A' and when there is pivot "B" .
I have tried various combinations of if( isfitered etc , but nothing seems to work.

Richard.

Thanks, once again, I think I may have been some time coming up with an 'or' to solve it.

Richard.