Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Instead of value List, you can add the expressions directly on the expression tab.
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.
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
Hi Satish,
Could you post the sample QV ?
Regards