Second header based on first header

[Anonymous]

Hi Community

For below example I have used valuelist('9Q Avg', '1Q16') as 3rd dimension.

I want different header for 1st column 'JO', let say valuelist('4Q15') else as mentioned above.

Any idea please?

Thanks

[#2]

Instead of value List, you can add the expressions directly on the expression tab.

[#3]

Hi Satish,

You can create a  inline table for these values  something like

Load * inline [

Header

'9Q Avg'

'1Q16'

];

drop this field in the dimension and   edit this column with expression like

if(field='JO','4Q15',Header)

change the expression set accordingly.

[Anonymous]

Hi Lokeshwari

This is excellent suggestion, but in expression how do I use formula like if '4Q15' than Exp1, if '9QAvg' than Exp2? Today I have posted same question again with sample QV, Please have a look.

I appreciate your efforts and time

Thanks

[#5]

Hi Satish,

Could you post the sample QV ?

Regards