Simulating a Pivot Table, but with the "SUM" formula created in Excel

[Luqman]

I am not sure if what i am asking is realistic


What I am trying to do is

1) Create a pivot
2) Be able to manually input numbers and have it updated in an easy to see manner

The results would be as per picture, i just need the "formula" of the pivot. However, I cannot imagine manually writing each formula in the tool.

Criteria :
The columns used are always the same.
unique data in each columns might change every month


If someone can direct me to another app that can do this(or if it can be done in excel), i would be grateful

PivotResults that I want

[rzdodson · Accepted solution]

@Luqman this should hopefully help you out. What I did was created the GHO Account Code total (first Summarize tool) and Grand Total (last Summarize tool), created a standard workflow to create the reporting structure from your Excel file (the macro in the middle), and then unioned those elements together to put it in a table to replicate the pivot table you created.

Feel free to reach out again if you are looking for something else. :)

Full Solution:

Macro