nicolaskruchten / pivottable

Open-source Javascript Pivot Table (aka Pivot Grid, Pivot Chart, Cross-Tab) implementation with drag'n'drop.
https://pivottable.js.org/
MIT License
4.33k stars 1.07k forks source link

Hide missing value but still use in denominator #1311

Closed ausfas closed 1 year ago

ausfas commented 1 year ago

I've large data set where some of the values in a variable are missing and they are quite in number. When I plot the data with missing values the missing value column (for bar plot) dwarfs other column values. However, if I don't use the value in the denominator then the calculations would be wrong. Is there a way that I can hide what values to be displayed as filtering out will effect the denominator. May be a good addition to be able to hide when values equal =missing or any other. This will help other if they want to hide data meeting certain criteria.

ausfas commented 1 year ago

Not needed.