Filter for particular column alone

[woMa]

Hi folks,
I create a report budget and actual till date, I need one more column as Prev as last day working hours for that particular client alone.
while i using filter it apply every column in table.
Is any possibility to create a filter for particular column alone?
How to resolve this problem?

Many thank you in advance.

regards Wolfgang

[BigChris]

You need a calculation for that column rather than a filter.

Code Select Expand

Case
  when [YourDateField] = [PreviousWorkingDay] then [YourMeasure]
  else 0
end

You might need to wrap a total around that.

[woMa]

Hello folks,
that's how I did it.

I do this in the formula for the data item:
instead of<Wert>
then case when <Filter>then <Wert>else null end

Only the filter does not pull. The restriction does not work. When I use it in the normal filters it works properly.
I find it very strange.  :-\

I wish you a nice Sunny WE.
VG Wolfgang

[Andrei I]

Look at running-total
It will generate a Window Aggregate Analytic function (like  SUM(col) over (partition by ...) )
Example:
https://www.cognoise.com/index.php/topic,36212.msg119396.html#msg119396