TimePeriod

[soniasweety]

Hi all,

I have a two  tables one is main table, one is SLA table

so I need to map the data based on type and task status I need to show the numbers . attached excel is the sample data

I explained with example in sheet1

can anyone suggest the way to achieve this?

Thanks

Sony

[soniasweety]

check the image

[antoniotiman]

This seems normal behavior.

Can You provide full screenshot ?

[soniasweety]

I have 20 dimensions ...one measure

[antoniotiman]

I'm sorry. I have no idea how this occur.

I need Your real data.

Maybe You need some change in Script according Your Data.

[soniasweety]

thanks Antonio. I will check with production data and come back to you. As sample data may not have exact issue.  the logic you provided is correct it seems

[soniasweety]

in btw One small Doubt Antonio Mancini           

I have other excel file which is also having same columns like  task ,type,critical,normal,medium,

like that but this time the SLA values are different ,how can I map this ? to  main table?

can you suggest anything?

Thanks

Sony

[antoniotiman]

It shold work as well.

You need match values between Type field

[soniasweety]

here the thing is

in 1 sla table I need to consider  particular type =task

both sla tables    Type values are same except 1/2   but  task values are more  .

so for that particular type and task is equal to priority values.