BrerRabbit
Board Regular
- Joined
- Aug 20, 2023
- Messages
- 84
- Office Version
- 2021
- 2016
- 2013
- Platform
- Windows
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?
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?