Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does anybody knows a way to put titles over groups of expressions in a pivot table like the attached image?
There is a trick, you have to define another dummy dimension (with load inline) and use it before your real dim.
Let me know
Alessandro Saccone solutions works well if you have same expresions for each value "Leitos"/"Paciente Dia", etc
Hi, Alessandro!
Can you show me how to do this?
Here is my qvw.
Sorry Fernando but I cannot download anything because my company policy ...
Clever, do you know a way to do this?
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
If you have same expressions for each group, Saccone post is the answer
Fernando
Anexei a sugestão do Saccone
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