using aggr() in calculated dimension

[#1]

Hi all,

I load an unit cost table to qvw by year, company, product and orginal_currency

and another rate table by year, month,original currency, reporting currency.

I created 2 aggr() in 2 individual calcuated dimension :

1. aggr(distinct(cost),year,company,product,orginal_currency)

2. aggr(max({<reporting_currency={'JPY'}>}rate), year, month,company,product,orginal_currency)

My question is if it's possible to create a new calculated dimension which is (1 * 2) .

Thanks,

Catherine

[Anonymous]

Hi,

You can add new dimension with calculated form (1*2) or just in text (one) or number (1) form.

[#3]

Sorry. My meaning is to add new dimension that multiply below 2 aggr() values Cost * Rate :

1. aggr(distinct(cost),year,company,product,orginal_currency)

2. aggr(max({<reporting_currency={'JPY'}>}rate), year, month,company,product,orginal_currency)