How can I prevent line reducing in a table?

[#1]

Hey community

I like to have three columns as in the first table. Column Date/time is a measure, where I need to use colors for the background. The other columns are dimensions.

The filter is set to smsDelivery for e.g. 17.722 There exist two lines with this number and I like to see both. But somehow the two lines will be reduces to one and the date will be shown as '-'.

The second table works because of the field callid, which is a unique field. But I like to have the table without the callid. Is this somehow possible?

I've also added an example file.

Thanks & Regards

Sarah

[prabhuappu]

Hi,

You can't show only one value if you use dual function

Regards,

Prabhu Appu

[#3]

Unfortunately the sales wasn't happy with the solution which shows double entries in the filter. So I'm going to remove the time coloring field and add it as a dimension...