Solved

Cube view filter gives strange data


The filter on the cube view does niet give the expected results. How is this possible? 

See image below, the filtered results are in the range until - 10.000, however, I see different results. It does not matter if the check ‘apply to specific level’ is on. Could anyone help me with this odd situation?

 

icon

Best answer by Mark Jongeling 11 August 2022, 15:00

View original

3 replies

Userlevel 7
Badge +23

Hi,

The screen says its for the Column field "Eindtotaal” but the red box is around the field "Resultaat”. Are these the same fields? 

No, but this is the filter screen you get when filtering the fields ‘resultaat’. 

Userlevel 7
Badge +23

Hi,

I think this may be because of that the Filter works on the dataset whilst the GUI is showing a #value which may be something like a Sum. I doubt the component can handle filtering on values after calculations.

Reply