Redefining Result rows in query output
I have following in rows and column for display in query
net pa | bill pa
Now i wanted the result rows to be displayed for PA1,2,3,4
so while running the query the result rows are displayed.
Now my user wants that to change the name of that result row from
Result to Subtotal
As well as he wants it like
Subtotal for pa1
Subtotal for pa2
Subtotal for pa3
Subtotal for pa4
How to do this.
He/she wants asetting that while running the report on Portal they have
THE ABILITY TO TURN ON/OFF THIS RESULT ROWS
How to provide that.
I think you know how to suppress totals but you are asking how to change the text in the system generate totals line - short answer is you can't.
Would you suppressing the characteristic totals and depending on your mix of char's and consider putting in a structure that has a formula to add the key figure which gives you the total. You may have to play a little bit with the mix of characteristics to get it right and it may not work at all. Just another thought!