Excel 2021 - Building a Pivot Table on a Filter Function Array

[BrerRabbit]

I previously built a dashboard built on a dynamic range of a table in order to omit the empty rows. Unfortunately the Data Model corrupted.

Am I able to somehow use the various filter functions in order to build a dynamic dashboard. the pivot tables do have functions I don't think I can do in filter arrays.

Bcuz of the dynamic nature of data, it was table>dynamic range>pivot table>pivot chart. I"m wondering if I can do table>filter>chart. Or are the charts going to be extremely simple?

 

[etaf]

you can pivot chart from a filter list , placed in a new sheet - just did it
OR do you mean the source data for the chart is using a filter, somehow
in which case not sure how you add that into the source chart data range

 

[BrerRabbit]

would this include or exclude any blank rows

the filter is based on teh source data

 

[etaf]

you can exclude blanks in the filter function

 

[BrerRabbit]

how did you pivot chart from a filtered list, and I mean array from the filter function, not using the drop down arrows.

 

[etaf]

i maybe have miss understanding what you want to do - sorry
i see what you mean now - dont know

 

[etaf]

researching - not sure how to get filter to spill into a table, so then the chart is dynamic from the table and the filter can remove the blanks - maybe need something like powerquery to create a table and then the pivotchart can use the table reference - but i don tknow how to use powerquery (only recently been available in Mac excel versions)

 

[BrerRabbit]

i maybe have miss understanding what you want to do - sorry
i see what you mean now - dont know

i don't know either but i appreciate teh assist. thanks. you can't do a filter array into a table.

 

[etaf]

you can't do a filter array into a table.

No, various suggestions on the web, are VBA & PQ - VBA i dont provide answers - too long ago when i used and as mentioned not tried PQ

 

[BrerRabbit]

yeah, i think i'm stuck with trying dynamic ranges again and hoping taht the data model doesn't explode. thank you anyway