manipulate data based on dimension value.

[#1]

Hello all,

I have a table and I want to manipulate its data based on the expression dimension value.

for example if my dimension value is "A" multipy the data by 100 and if the dimension value is "B" divide the data by 100.

any ideas can this be done?

I am think the best will be to manipulate the data on the loadscript so afterwards I will be easier to use them in different tables without having to write any complex formula every time.

Regards,

Savvas

[renjithpl · Accepted solution]

Hi Savvitos,

You can try something like this in the edit script

Sum(if(Dimension ='A', Value)) * 100 as XXX,

Sum(if(Dimension ='B', Value)) / 100 as YYY

Then you can select XXX or YYY in your dimensions.

Regards