Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried using the Number's tab for doing this?
i have tried , but it is not working.
Only Total amount should be 24.55
You can use function Dimensionality() in Expression for custom total values:
If(Dimensionality() > 2, Sum(Amount) , Num(Sum(Amount)/1000000, '##.00') )
Try this expression
if(sum(Sales)>=1000000, 'M '&sum(Sales)/1000000, sum(Sales))
Try with dimensionality() like:
If( Dimensionality()=0 , Num(YourExpression/1000000, '##.00')&'M', YourExpression)
PFA Demo
Vikas
Hi,
Try liek this
If(RowNo() = 0, Sum(Sales)/1000000, Sum(Sales))
Thanks ,
But your expression is not working ,
I think you all understanding my question wrongly , please see below screenshot , what i need.