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

[kaushiknsolanki]

Hi,

Use the Tablebox object instead of Chart object.

Regards,

Kaushik Solanki

[Anil_Babu_Samineni]

May be use straight table with Dimension as country and currency

Expression is Sum(amount)

And hide the dimension from presentation tab.

[avinashelite]

Try like this

sum(TOTAL<currency> amount)

[Anonymous]

Hi Anil,

As I mentioned above I don't want to use dimension currency and hide it in chart ,

I want achieve with only country as dimension and sum(amount) as expression

[Anonymous]

As I Mentioned above I have to do this only straight table

[Anonymous]

Tried all the ways but no luck

[tresesco]

Is using a calculated dimension an option or even making changes in the script (may be adding a field)?

[Anil_Babu_Samineni]

Okay

[Anonymous]

only in ui level I want do that ,

its direct dimension