By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
1
Posts
1
Users
1
Reactions
1,008
Views
June 5, 2022 8:50 am
Hi,
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.