Title Over Expressions

[#1]

Hi,

Does anybody knows a way to put titles over groups of expressions in a pivot table like the attached image?

[alexandros17]

There is a trick, you have to define another dummy dimension (with load inline) and use it before your real dim.

Let me know

[Clever_Anjos]

Alessandro Saccone solutions works well if you have same expresions for each value "Leitos"/"Paciente Dia", etc

[#4]

Hi, Alessandro!

Can you show me how to do this?

Here is my qvw.

[alexandros17]

Sorry Fernando but I cannot download anything because my company policy ...

[#6]

Clever, do you know a way to do this?

[alexandros17]

Load * inline [

myDim

Description_To_Add

];

Now, in every table where there is one of the field Leitos, Paciente, Ocupation add for each value the value

Description_To_Add.

The result must be:

... myDim, Leitos, Paciente, Ocupation

Description_To_Add, val1, val2, val3

Description_To_Add, val6, val5, val9

....

At this point using myDim as dimension you will see Description_To_Add as description and other fields below

[Clever_Anjos]

If you have same expressions for each group, Saccone post is the answer

[Clever_Anjos]

Fernando

Anexei a sugestão do Saccone

[#10]

Clever,

Obrigado, mas verifiquei que os título aparecem em todas as expressões.

A intenção é aparecer assim como na imagem que anexei no primeiro post