create pivot report with additional fields

Summary:

in fusion i want to create income statement report as pivot table , i know how i create pivot in template.

but

the first issue is i get some accounts the get summation of these accounts and so on.

the second i need to get additional fields depends on summation of accounts and create a calculated columns depend on data on pivot table.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):