pivot table numbers

[#1]

Hi All,

I am facing issue. I have following tables: Date_Table & Account.

Both table has Eve_date column common. I am using Eve_Date ( Date Table) in dimension & Sum(Actual Efforts ) from Account table in pivot. It should show all the dates from Date Table. But it is not showing.

I have used supres 0 values. I have join both table with Left Keep, but still it is not showing expected output.

Please help.

[Anil_Babu_Samineni]

Then, Instead of NA in presentation tab use Space to hide. Why you want to show in condition.

[#3]

I am using Dimension "city" and formula that =If(sum(Emp)>0, Green, Red). where there are some city that doesnot has emp, it shows null & applying red format. I want to treat NULL as white.

[Anil_Babu_Samineni]

May be Application needed for this Issue

Try this for luck

=If(sum(Emp)<0, Red(), Green())

[#5]

Not working. Tried already.

It  considered text what ever you put for null values even 0 is considering text. So < 0 is not working

[Anil_Babu_Samineni]

Can you share the application please? That demonstrates the issue

[#7]

i am working on trial version now. so can not share any file.

but my concern is that I want to format NULL ( what ever we defined in show null values) in Pivot table. Formatting means background color and font color only.

Please guide me on this.. stuck from long time.

Thanks in Adv

[tyagishaila]

Go to Expression Tab

Explore expression(click on + sign)

click on background color then write expression

If(field or expression whatever=NA, Yellow, red or green as per your requirement)