Assigning a value to Pivot

[ferha_jafri]

 Hello Experts,

I need your help , in the attached application I want to assign time T2 and T3 value for time T1 and I am using T1 as dimension. I want in that way without using creating data island , so please let me know whether it is possible or not without data island. I am sure somebody has a solution to it.

Thanks in advance

Ferha

[vivek_gajjar01]

If I've understood your question correctly. Then try the following expression: 

If(Time='T1',sum(aggr(Sum({<Time = {'T2','T3'}>}ID),Product)))

[dplr-rn]

try attached. updated the expression

[ferha_jafri]

Not getting the desired ans in the application , not sure what is going wrong.

[dplr-rn]

whats your desired output?

[ferha_jafri]

If(Age_Band_Dispatched='Dispatched on T+0',sum(aggr(Count({<Age_Band_Dispatched = {'Dispatched by T+1','Dispatched by T+2'}>}Conf_ID),Conf_ID)))

Using this expression but not getting the desired result

[dplr-rn]

you really need to provide more details. the expression seems to nothing to with the sample app.

share a sample app which represents your data properly. share what the desired output it and then we will be able to help.

[ferha_jafri]

Hello ,

Now in the attachment I want in the column Dispatched by T+1 Have value Count ID for 'T+2',T>2'

Thanks 

[Kushal_Chawda]

see attached

[ferha_jafri]

No , not the desired result as I want to have column in the pivot only and in Column T+0 i WANT T+1 + T+2 = 2606