I've created a generic inquiry, which pulls record from project transaction record table and based on that GI, I've created a pivot table, which will display month wise project balance for each account group and project. now i want to add another column to display total of current month + last month. how can i achieve this ?
So if you look at screenshot, i want another column in pivot table as running total (which will display current month + previous month total). eg 16591.71 + 4190.54=20782.25 in 03-2022 period.
I’m not sure you can do this so easily in a pivot table. It might be possible with some clever cross joins, but that could get messy and probably not very efficient.
A couple of other ideas:
You could possibly build this using the Acumatica Report Designer. With the Report Designer you have the ability to use variables for running totals, conditionally hide certain sections, and so on. It’s not quite as interactive as a Pivot table, but you can still configure drilldown.
Probably the easiest solution would be to create the report in Excel. Have you looked at the Velixo add-in? It makes it very easy to build these sorts of financial and project reports directly in Excel.
I’m not sure you can do this so easily in a pivot table. It might be possible with some clever cross joins, but that could get messy and probably not very efficient.
A couple of other ideas:
You could possibly build this using the Acumatica Report Designer. With the Report Designer you have the ability to use variables for running totals, conditionally hide certain sections, and so on. It’s not quite as interactive as a Pivot table, but you can still configure drilldown.
Probably the easiest solution would be to create the report in Excel. Have you looked at the Velixo add-in? It makes it very easy to build these sorts of financial and project reports directly in Excel.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
