Adding calculated field based on exp pivot table

[#1]

Hi Team,

I have a table with

cost center,employee name,project name,year-week,planning hours

so whenever there is no planning hours (meaning planning hours=0 ) i am not getting recor since suppress zero value is checked.

Now the requirement is to show employees even though the planning hours=0.But they dont want to see project name.

generally this is what iy comes if i allow zero.

cost center,employee name,project name,year-week,planning hours

CC,name,proj1,year-week,0

CC,name,proj2,year-week,0

CC,name,proj3,year-week,0

but need is,

CC,name,' ',' ',' '

kindly help.

[rahulpawarb]

Hello Prajna,

Please use below given calculated dimensions & expressions:

//project name
=If([planning hours]>0, [project name], '')

//year-week
=If([planning hours]>0, [year-week], '')

//planning hours
=If([planning hours]>0, [planning hours], ' ')

Regards!

Rahul

[#3]

if i give this in dimension i was getting error in calculation dimension..but if i use aggr function is not throwing error.

so em stuck

Regards,

Prajna

[rahulpawarb]

Hello Prajna,

Could you please share the application with sample data? This will help me to provide your expected response.

Regards!

Rahul

[nagarjuna_kotha]

this information is not enough,

Try to share sample data along with expected results.

-nagarjun