Text Object - Multiple Rows Combining Dimension and Expression

[#1]

Hi

I am trying to create a Text Object which gives me a Dimension, a Date and two Expressions, that will display multiple rows of data. This will be the basis for an Alert to be sent by email. The data is to be restricted by two filters. One is to restrict data to today (Is Latest = 1) and the other to show data count is down (Record Count Travel = -1).

The output I would like to see is:

report1     25/10/2016     550     500

report2     25/10/2016     600     590

report3     25/10/2016     700     680

Column 1 is the Dimension - [Report Name]

Column 2 is the Date - [Document Date]

Column 3 is the Count Today - [No of Records]

Column 4 is the Count Yesterday - [Prev Count]

The following works, if I physically filter "Is Latest" and "Record Count Travel", but I would like the result to apply even without the filters applied.

= concat( if([Record Count Travel] = -1, if([Is Latest] = 1, [Report Name]))

& '          ' & if([Record Count Travel] = -1, if([Is Latest]= 1, [Document Date]))

& '          ' & if([Record Count Travel] = -1, if([Is Latest]= 1, [No of Records]))

& '          ' & if([Record Count Travel] = -1, if([Is Latest]= 1, [Prev Count]))

& chr(13) )

I've tried some Set Analysis options too. Can't work it out...

Any help would be appreciated.

Kind regards

Tony

[sunny_talwar]

May be like this:

=Concat({<[Record Count Travel] = {-1}, [Is Latest] = {1}>} [Report Name] & '          ' & [Document Date] & '          ' & [No of Records] & '          ' & [Prev Count], Chr(10))

[#3 · Accepted solution]

I worked out a different way to do this and used a Macro, to email a chart object instead.