Total in Million on chart

[agni_gold]

Hi Experts ,

I have a situation , i have made one chart , like below ,

But i want the total amount should be in million. Rest will be the same.

Please help

[sunny_talwar]

Have you tried using the Number's tab for doing this?

[agni_gold]

i have tried , but it is not working.

[agni_gold]

Only Total amount should be 24.55

[asgardd2]

You can use function Dimensionality() in Expression for custom total values:

If(Dimensionality() > 2, Sum(Amount) , Num(Sum(Amount)/1000000, '##.00') )

[#6]

Try this expression

  if(sum(Sales)>=1000000, 'M  '&sum(Sales)/1000000, sum(Sales))

[tresesco]

Try with dimensionality() like:

If( Dimensionality()=0 , Num(YourExpression/1000000, '##.00')&'M', YourExpression)

[vikasmahajan]

PFA Demo

Vikas

[jagan]

Hi,

Try liek this

If(RowNo() = 0,  Sum(Sales)/1000000, Sum(Sales))

[agni_gold]

Thanks ,

But your expression is not working ,

I think you all understanding my question wrongly , please see below screenshot , what i need.