Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've come across a question from a collegue that wants to work a calendar to follow tasks of his team.
Has anyone managed to thought of a way to display text in pivot tables as expression?
=only([]) doesn't work.
Each task has a slew of characteristics by wich to filter afterwards like clients, priority, frequency, etc.
He wants to easily select these criterias to see what goes on in that segment.
Yes, you could return strings within a pivot, like:
'x (' & sum({< Type = {'x'}>} Hours) & ')' & chr(10)
'y (' & sum({< Type = {'y'}>} Hours) & ')' & chr(10)
....
- Marcus
true, but every task that is added, substracted to the workload has to be handled manually in the expression.
that's a good lead though thanks.
This might be possible in a more generic way with a concat and extend with a dual with something like this:
dual(concat(distinct Type & ' (' & sum(aggr(sum(Hour), Staff, Date)) & ')', chr(10), TypeID), sum(Hour))
- Marcus
I'll have to try that, will let you know