Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If I've understood your question correctly. Then try the following expression:
If(Time='T1',sum(aggr(Sum({<Time = {'T2','T3'}>}ID),Product)))
try attached. updated the expression
Not getting the desired ans in the application , not sure what is going wrong.
whats your desired output?
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
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.
Hello ,
Now in the attachment I want in the column Dispatched by T+1 Have value Count ID for 'T+2',T>2'
Thanks
see attached
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