Pivot table with text as expression

[sibrulotte]

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.

[marcus_sommer]

Yes, you could return strings within a pivot, like:

'x (' & sum({< Type = {'x'}>} Hours) & ')' & chr(10)

'y (' & sum({< Type = {'y'}>} Hours) & ')' & chr(10)

....

- Marcus

[sibrulotte]

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.

[marcus_sommer]

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

[sibrulotte]

I'll have to try that, will let you know