Replacing the result row with a new row

[former_member317899]

Hi ,

I have a query which has Tax Category as row and Base(Formula) and Tax Amount as columns. The result row is made as "always display". Now,the customer wants me to suppress the result row and include the row "Total sales including Tax" which contains the sum of the amounts of columns "Base" and "Tax Amounts", and behave as the result of the report.

Can anyone please guide me how to do this.

THanks in advance

Regards

Manjari.

[former_member183777 · Accepted solution]

Create a new formula in the columns under key figures with the desired name requested by customer. Define this formula as Base + Tax amount. Then you can either drag the key figure structure to rows, so for each tax category the output will have three rows, base, tax and total of base and tax.