Skip to main content
Answer

Cube view filter gives strange data

  • May 6, 2022
  • 3 replies
  • 101 views

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?

 

Best answer by Mark Jongeling

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.

This topic has been closed for replies.

3 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+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? 


  • Author
  • Rookie
  • June 2, 2022

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


Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • Answer
  • August 11, 2022

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.