Change the TOTAL text in Data View
Accepted Answer
-
Hi @Efraim ,
you would need another member that you might call "my new Total" and sum up all others into this one by applying the rule. Then you could use the rule to display the totals with a new name in the rows.
Usually you would use a rule for a P&L structure.
Make sure not to use downtotals on your columns and de-select the total-member if you want to use it otherwise.
I'm not sure if this approach will help you achieve your aim but on the other hand the text "TOTAL" (both on the rows and the columns) can not be changed.
Best,
Helmut0
Answers
-
Hi Efraim,
Not sure that you can change the column header, however, for the line header, you can explore the possibility to apply a Rule on your dataview, choosing the name of the total that you will set up there. Here some guidelines if needed:
Best regards,
Adrien
0 -
Hello Adrien,
Thanks for your response!
I checked the Rules but it looks like I can only add formulas that refer to other Entity Members.
I can't find any TOTAL line in there that I can edit0 -
Thanks @Helmut Heimann!
This answers my question.0