Filter dimension

[#1]

Hi,

How I can filter dimension ?

I have imported my data and in one column there are three different values like be, ge and re. I would like to use only ge values on graph.

Can I filter data or do I need to import data with other load statement with where clauser ?

BR, Hietsu

[#2 · Accepted solution]

You can filter the data in the pivot/chart

e.g. This filter and sums all values in warehouse 06

Sum( {$<warehouse={06}>} Value)