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
You need a calculation for that column rather than a filter.
Case
when [YourDateField] = [PreviousWorkingDay] then [YourMeasure]
else 0
end
You might need to wrap a total around that.
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
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 (https://www.cognoise.com/index.php/topic,36212.msg119396.html#msg119396)