How to show BLANK i straight table if data not available for a particular region

[#1]

I am calculating the revenue data across regions.

I have a Region field.

But for some Regions revenue data is not there in the database. Revenue column against those regions are showing BLANK in database.

So, in staright table, when I take REGION as dimension and sum(Total_Revenue) expression as expression,

For those REGION's where Revenue data is BLANK in database is coming as 0.0

This should not happen.

I want those cells where Revenue data is not there in the database to be shown as BLANK in my straight table instead of showing as 0.0.

How do I do this?

Pease help me friends.

Thanks,

SHAMLY P T

[Chanty4u]

try this

if(Region>0,Region,0)

[tamilarasu]

Hi,

Change your expression as

If(sum(Total_Revenue)<>0,sum(Total_Revenue))

Or

If you don't want to modify your expression, you can try to change the number format in chart properties.

Format -> #,##0;#,##0;-

[Chanty4u]

or

IF ( SUM(Region)<0 , null() , SUM(Region) )