i need to create a pivot table as follows
Here Discipline is the dimension and Rest all are Expression
i have to create an additional Heading ,(Productivity,Lock Up etc..) for specific Expressions as shown below.
is there Any possible way to achieve this??
You can use ValueList() function to create a new dimension:
Something like this:
ValueList('PRODUCTIVITY', 'LOCK UP' and so on...)
and then use that within your expression like this:
If(ValueList('PRODUCTIVITY', 'LOCK UP' and so on...) = 'PRODUCTIVITY',
yourExpression) for your Hours expression
Are you using the same if for all of them? For Dbors TOTAL you need to do like this:
If(ValueList('PRODUCTIVITY', 'LOCK UP' and so on...) = 'LOCK UP',
yourExpression) for your Dbors TOTAL expression.
Need to make sure that you select the correct place to put your expressions.
Let me know if it is still not clear.
So I have this thus far. May be somebody knows a way to remove the empty columns where all the values are null. i tried doing suppress null value but that did not help. Attaching my qvw for others to play with.