Define a dynamic data range for Pivot charts

Hi

I've got a dataset built using thw JFX row function so that it compiles data based on a series of filters.

The number of lines that final data set takes up is entirely dependent on the filters so its making building a pivot chart slightly awkward. I could specify a table range i.e. $D5:$P2000 however this will create blanks in the filter.

Is it possible to Define a Name that is dynamic to the number of rows the query returns e.g. I defined a name based on $D2:$P3 in the design wizard however when reporting is only returns the results from row 3, I was hoping that it would grow based on the returned data.