You need a browser which full supports HTML5 Canvas to run SpreadJS

Select the slicer and then change the options.

Check this box to show the unfiltered data items last in the slicer.

Check this box to gray out items that aren’t present in the table.

H