The dimension can be mapped to one column source only. In general, the pivotgrid supports only filter by label
. If you would like to filter by value
, then I will suggest you filter the flat data before passing it to the widget. This will give you the ability to filter the data correctly (not the aggregated values) and then categorize it using the widget cube.
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI