I am creating report in DV which were previously created using Oracle Classic BI. When creating the table, there are columns where it is showing blank in cells where there are no data. However, in Classic BI the blank cells are shown as 0. When I checked the column properties in Classic BI, it has added Custom format as #,##0;-#,##0;0. But there is no option in DV. Screenshot attached.
Also please suggest, how to rename the Grand Total column. There are two grand totals in my table,
1. Which is supposed to be named as Amount instead of Grand Total Amount and
2. Need to call it as Count instead of Grand Total Count.The Amount column is renamed and is working as expected.
However, when I tried to change the Grand Total Count to "Count", it doesn't change and stays as "Grand Total Count". I thought "Count" must be keyword and tried using other text, but it doesn't change. Screenshot attached, Please suggest.
