Skip to main content
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?

 

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.

View original
Did this topic help you find an answer to your question?
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
  • 2 replies
  • 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
  • 3945 replies
  • 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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings