Expression to dimension

[#1]

Is there any code to change an expression to an dimension? (eg. sum(object) )

[alexandros17]

Any aggregation function (e.g. sum, avg, count, aggr .. etc) is performed through dimensions so you can't use these function in dimension ...

Hope it helps

[#3]

Description	TYPE	Jan2011-Jan2012	Jan2012-Jan2013
ASD	PENC	13123	7898
UHT	OPSI	12312	4356

This is an example on what i need to achieve. I have already set TYPE as an expression because 'PE' and 'NC' are two different field. It seems like i'm having two expression but i cant do it.

[#4]

Hi

just do it in ETL..Pls find below script..hope it will help u..

RawData:LOAD * INLINE [
Product,   Price,     Volume
P1,  10,  40
P2,  12,  50
P3,  20,  60
P4,  5,   70
P5,  15,  80

];

Data:LoadProduct,
     Price,
      Price As Value,
     'Price' As 'Measure',
           Volume
          Resident RawData;

Load

Product,
  Price,
    Volume As Value,
   'Volume' As 'Measure',
     Volume
          
     Resident RawData;
     DROP Table RawData;

In Chart take Dimension as Measure and in expression Sum (Value)

Regards-Bika