How to eliminate duplicate dates in webi

[Former Member]

I'm creating a Webi report from a query (BW). I am not able to avoid duplicate date fields

Date Division

2/1/2017 10

2/1/2017 20

I want to show date only once like

Date Division

2/1/2017 10

20

Format table is not resolving my issue and my query properties for duplicate rows in not in a edit mode.

[amitrathi239]

if you don't want to repeat the same date value and want to display both division values then use Break on Date field.