Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Now i have date field as below and calls field, now i have to display the result as below,i want to show the one date and the count of calls as 20,can any one help on this.
Result:
Date Calls
1/1/2014 20
Date Calls
1/1/2014 5
1/1/2014 5
1/1/2014 5
1/1/2014 5
Thanks & Regards,
Sivakumar
Hi
Try like this
Date as Dimension
Sum(calls) as expression
Edit:
In text box:
='Maximum Date' & Date(Max(Date)) & '---------' & 'No of calls' & Sum(Calls)
hope it helps
Text box:
='Date : ' &dateField& Sum(Calls)
Select a date to get the output.
Hi,
Try like this
='Date : ' & Only(Floor(Date)) & chr(10) & 'Number of Calls : ' & Sum(Calls)
Hope this helps you.
Regards,
Jagan.
kindly find attatch file this may help you
Regards
fahad
Hi All,
Thanks for all your help now in the below case how can i do .
Date Calls
1/1/2014 5
1/1/2014 5
1/1/2014 5
1/1/2014 5
1/2/2014 5
1/2/2014 5
Result Should be :
Date Calls
1/1/2014 20
1/2/2014 10
can any one help on this.
Thanks & Regards,
Sivakumar
HI
Try like this
Date as dimension
Sum(Calls) as expression.
Straight table:
Dimension: Date
Expression:=Sum(Calls)
Hi,
Use Straight Table and try like this
Dimension:Date
Expression: Sum(Calls)
Regards,
Jagan.
Hi Tresesco,
Its possible to display through code in the text object?
Thanks & Regards,
Sivakumar