Hi, I am creating a report with "chart field1 field2", field2 only has 2 values. So the result has 3 columns: Field1, Field2Value1, Field2Value2. And I'd like to use addtotals and addcoltotals for each row and each column.
The issue I am having now, is that value of field1 are numbers so they are counted by both addtotals and addcoltotals, which I don't want.
I believe the easiest way is to convert the type of Field1 to string, with certain format, like number "12345" to string "12345", number "123" to "00123". I have tried tostring. But they are still counted.