Hey Guys,
I need your help to devise a Frequency with Subtotal Function Element type formula similar to the one below to perform a Dynamic Histogram when filters are on or off. I envision thE formula calculating a histogram dynamically when a specific scope is filtered or not. In Range (M5:N13) I have a Frequency Formula in there that moves with linked data, but I just noticed it doesn't adapt to filtered data.
I really appreciate your help on this.
Bookmarks