Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
in pivot data is possible to be display vertically? Only highlighted one.
I have attached QV file.
Thanks
Hello Satish,
Do you want like this?
F1 | F2 | Tx | TX1 | Amber | Green | Red | Unknown |
---|---|---|---|---|---|---|---|
A | 1 | Amber | 1 | 1 | 1 | 1 | |
G | 3 | Green | 1 | 1 | 1 | 1 | |
R | 2 | Red | 1 | 1 | 1 | 1 | |
U | 4 | Unknown | 1 | 1 | 1 | 1 |
hi
Yes It is Possible
Regards
Tahemas Momin
I want like this but only circled columns with fully expanded
Thanks
Even I'm ok with above scenario but the problem is as soon as I add another Expression
Tx's value displayed horizontally.
How do I keep displaying data vertically even with more than one expressions.
Thanks
Within the object-properties in tab presentation is an option to display the header vertically but this includes the complete header - all dimensions and all expressions. There are no more options to adjust this but maybe the following workaround is applicable for you: Re: Vertical Data Text in Pivot Table.
- Marcus
Hello Satish,
Go to chart properties> presentation>vertical text on column labels.
Disabled the this check box.
It works with only one expression, more than one expression it does not work.