small req

[Anonymous]

Hi All,

I have table like this

load * inline [

country,currency,amount

ind,inr,1.5

ind,usd,2.5

ind,,aud,3.5

];

I want to do this only ui chart level  straight table,

my dimensuion is country and expression is sum(amount)  so charts shows

ind  7.5  which I don't like to see aggregate the value

I want see in chart it self

ind 1.5

ind 2.5

ind 3.5

but if I add currency as other dimension then I am able to see the result (where I don't want add and hide the dim3endion)

how to achieve this

[tresesco]

May I know the business requirement that makes you put so many constraints? Or, this is just a possibility check?

[effinty2112]

Hi,

You could use a straight table with dims country and amount. No expression - suppress zero values in Presentation tab. This will in effect turn your straight table into a tablebox.

cheers

Andrew

[Anonymous]

Pls look at attached link

[Anonymous]

I have attached requirement in app

pls find attached qvw on thread

[Anonymous]

attached the qvw pls have a look anil

[kaushiknsolanki]

Hi,

You should use the sum(EADoriginalcurrency*currencyrate)

Because what you are looking for is the weighted sum.

Try it and let us know.

Regards,

Kaushik Solanki

[Anonymous]

I cant do that reason is

sum({<PERIOD={201703}>}EADoriginalcurrency) * SUM({<PERIOD={201702}>}currencyrate)

EAD ORIGINALAMOUNT WILL BE taken for prd month , currency rate will be for compariusiion month