Cumulative Total For Rows And Dates

[Todd]

I am using the Pivot Table control and would like it to display cumulative totals across a row displaying the previous column total even if that period does NOT have any values (in this case, no Amount for 2024-02).

Data:

Period       Amount       Product

2024-01           2             Prod A

2024-03           3             Prod A   

Desired Result Cumulative Product Amount:

Product                   2024-01       2024-02       2024-03

Prod A                           2                   2                   5

Is this possible using the Pivot Table and not writing additional sql code using CTL?

Todd

[Mohanraj Elumalai]

Hi Todd,

We understand that you want to display cumulative totals across a row by carrying forward the previous column's total. If so, our Pivot Table supports the Running Total aggregation type, which calculates cumulative totals by adding the current cell value to the total of all previous values in the specified direction (row-wise or column-wise), instead of displaying individual values.

However, we encountered an issue when binding the value axis in the row and applying the Running Total to the value field. This is a known issue, but we have now resolved it on our end. The fix will be included in the second weekly release of March, scheduled for rollout on March 11, 2025. You can track the status of the issue using the below feedback.

Feedback: https://www.syncfusion.com/feedback/65866/exception-when-using-runningtotals-aggregation-in-row-axis

Output Screenshots:

Before:

After applying Running Totals:

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization”.

We appreciate your patience until then.

Regards,
Mohanraj Elumalai

[Todd]

Thanks Mohanraj,

Look forward to the update so that my app works correctly.  If you can send a package for me to install manually it would be appreciated prior to the 3/11 release.

Thanks,

Todd

[Sridhar Karunakaran]

Hi Todd,

We understand that you require a custom NuGet package for the fix. If so, we have provided a sample along with the custom NuGet package for this issue fix. Please find the attachments below and refer to the Word document for step-by-step instructions on how to refer the provided NuGet package into your Blazor Pivot Table application.

Please let us know if you need any further assistance!

Regards,

Sridhar Karunakaran.

Attachment: SamplewithCustompackage_a2053f9b.zip

[Todd]

I tried installing the updated control you provided but it required updated pivot chart, and several other controls in the updated version so there was a compatibility issue.  I will wait for the 3/11 update when all controls are from the same version.

Thanks for solving this for me.  I look forward to using the updated control on 3/11.

Todd

[AngelinFaithSheeba PaulvannanRajadurai]

Hi Todd,

Thank you for the update. We have provided a custom NuGet package in the v28.2.7. If you encounter compatibility issues with this version in your application, please share the version you are currently using. Based on that, we will provide a custom NuGet package that matches your required version, allowing you to use other components with the same version and avoid compatibility issues.

Once we provide the custom NuGet package for your version, you can verify the fixes in your application. If you encounter any further issues, please report them to us, and we will address them as quickly as possible in the upcoming weekly release, if feasible.

Please let us know if you need any further assistance!

Regards,

Angelin Faith Sheeba.

[Todd]

Thanks for offering to provide the custom package specific to the version I am using.  I am using the Blazor version 28.2.9 controls.

Todd

[Sridhar Karunakaran]

Hi Todd,

Thank you for your update. As per your requirements, we have prepared a custom NuGet package to address this issue, along with all other components for version 28.2.9. Please find the package at the Google Drive link.

Google Drive link: Custom NuGet package

Please let us know if you need any further assistance!​

Regards, 
Sridhar Karunakaran.

[Sridhar Karunakaran]

Hi Todd,

Thank you for your patience. We are glad to announce that our weekly release, V28.2.11, has been rolled out. This release includes a fix for the reported issue: "Exception when using RunningTotals aggregation in row axis". Additionally, we have prepared a sample using the latest version for your reference. You can find the sample in the attachment below.

Output Screenshots:

Issue root cause:

This issue occurred because, while using the RunningTotals aggregation on the row axis, we attempted to access pivot values using an incorrect index. This resulted in the reported "index out of range" error. The problem has now been resolved by correctly accessing the pivot values with the appropriate index.

Please refer to the release notes below for your reference.
Release notes: https://blazor.syncfusion.com/documentation/release-notes/28.2.11?type=all#pivot-table

Please let us know if you have any concerns.

Regards,
Sridhar Karunakaran

Attachment: Blazorserver9_c8ccde6c.zip