Pivot Table

[upaliwije]

I have following pivot table in My qv document

YEAR	2010	2011	2012	2013	2014
STANDARD_DAYS_PM	35	37	46	31	31
ACTUAL DAYS PER MONTH	326	301	384	273	286
STANDARD_DAYS_PM	33	36	38	37	38
ACTUAL DAYS PER MONTH	111	129	138	138	146
STANDARD_DAYS_PM	24	38	39	40	41
ACTUAL DAYS PER MONTH	15	25	26	26	27
STANDARD_DAYS_PM	17	32	33	34	35
ACTUAL DAYS PER MONTH	15	31	32	33	35
STANDARD_DAYS_PM	27	31	32	33	34

I want to adjsut width of YEAR columns to be exactly like above and fisrt coloum with to be wider. But if I adjsut the width first column width of all other columns too expand. Is there any possibility of expanding the with of 1st coloumn only. The fist colum is an expression add year columums is a dimension

[upaliwije]

Hi Thanks

Yu can use BCOD as a Dimension

[MarcoWedel]

There is no BCOD field in your sample application ...

hope this helps

regards

Marco

[upaliwije]

It is there

[petter]

I would be practical about it and use abbreviations with some legend explaining the abbreviations next to it:

In my opinion this is much more readable too ...

[petter · Accepted solution]

In addition to the "practical" straight-forward approach I mentioned over there is a way of achieving exactly what you want.

The downside is that it is much more complicated and you will have to have a calculated dimension and a single expression with a Pick() function. In addition you will have to use a ValueList()-function to generate values for the calculated dimension.

1) Add a variable in the "Variable Overview" like this:

2) Add a Calculated Dimension amongst your dimensions like this:

3) Then finally have this single expression:

This will pick the right expression according to which dimension value that appears on each row.

Now you can size the calculated dimension column width independently from you expression.

I have attached your QVW with the updates to show have the final result will be and works in with your test data.