Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can add new dimension with calculated form (1*2) or just in text (one) or number (1) form.
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)