Total Including Null value in pie chart

[Rajkumar]

Hi all,

In Pie chart I am getting total value though I removed Null from dimension. Example

CITY  ,COUNTRY,sales ,sum(total sales)

DUBAI , UAE ,10, 80

ABUDHABI,UAE,30,80

SHARJAH,UAE,30,80

-,UAE,10,80

If I remove Null I have to get total as 70 not 80 .If I use expression sum(total sales).

Can anyone suggest the solution to get 70.

[Anil_Babu_Samineni]

Perhaps this

sum({<CITY-={"=null()"}>}total sales)

Or

sum({<CITY-={"=Len(CITY)=0"}>}total sales)

[Kushal_Chawda]

@Rajkumar  try below set expression

=sum(TOTAL {<CITY={"*"}>} sales)