I can create a pivot table with an explicit range for the source no problem:
$Income.$A$1:$D$7
But when I try to create a pivot table with an endless range for the source e.g. all rows after the header, the source text goes white and the pivot table is not correct:
$Income.$A$1:$D
How can I specify an endless range for the source without including blank rows?