BEx Query Column Format

[Former Member]

I have a simple Query at the mo that has Employee / Master Cost Centre in the rwos and an amount key figure in the columns. Output is Employeee:Master Cost Centre:Amount. Is it possible to make it so Employee and Mater Cost Centre remains as rows but the output has the format Employee / Amount / Master Cost Centre?

Thanks

Joel

[Pravender]

In 3.5, you can use Tabular query display and change the format and in BI7 create a formula variable using keyfigure and put it between characterstics.

[Former Member]

Thank you for your help. I'm on BI7 so I need to use the formula variable option. I've never done a formula variable - how do i create one. I've added a structure to my rows - click create formula - I've clicked to create a new variable but where do i go from here - what do I put in the variable I am creating?

[Former Member]

When you're in the formula edit, in the bottom left had box there will be the objects you can add to your formula. At the bottom of this list are formula variables. Inside that area you can create new formula variables.

[Former Member]

I've clicked on create formula variable but I've no idea what to put in it? How do I get this to provide the same data as the key figure I want?