Expression columns in a simple table

[#1]

Hello,

I need to make a simple table with a lot of expressions, so I need to make some columns,

ex:

actual table:

market_id     

1                   sales today                 100

1                   sales week to date       200    

1                   sales month to date      500

1                   sales year to date        1400

desired table:

market_id     

1                   sales today                 100          sales month to date      500

1                   sales week to date       200         sales year to date        1400

I don't see any option to do it, is it possible???

Regards,

David

[its_anandrjs]

Hi,

I dont understand your reqs as i understand you want to load two tables with same field names or want to represent as it is display right now in the table desired table. Do you have any sample if so please provide it.

Regards,

Anand

[#3]

Hi,

I need to represent several columns expressions it in the same table,

if I split the data in two different tables I'll have two scrolls and I don't want it...

Regards,

David

[#4]

Look into using a chart set to straight table or pivot table, which you may want to be "Always Expanded".  A normal table does not support expressions.

[its_anandrjs]

Hi,

As you say you want to display several columns expressions in the same table in this case one of the things you use try to create expressions in Variables or use in in the Straight Table or Pivot Table. and you use multiple expression there as a column expression.

Regards,

Anand

[#6]

Hi,

I have done with valuelist(actual,ly,ytd) as a dimension

and in the expression something like this:

if (valuelist(actual,ly,ytd))=actual,'' actual_expression1",

if (valuelist(actual,ly,ytd))=ly,"ly_expression2",

if (valuelist(actual,ly,ytd))=ytd,"ytd_expressionn")))

Thanks for your help,

David

[#7]

Hi,

Was about to ask virtually the same question!  Many thanks for the info!!

Cheers,

Emma