We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Something wrong with IPivotField's PivotFilter

Thread ID:





132321 Aug 26,2017 01:46 AM UTC Aug 28,2017 12:32 PM UTC WinForms 1
Tags: XlsIO
Asked On August 26, 2017 01:48 AM UTC

I have 2016 and 2017 (in the SalesDate Field, it has sales data every month) sales data for two years, and I want to use PivotFilter to filter the SalesDate Field as follows:

Sorry to say that it doesn't work well, I only want Sales Data of this year 2017,  but when I open the generated excel file, there is no data in the pivot table.
I don't know how to make it work.
Do you guys have some sample code? Thank you very much.

Sridhar Sukumar [Syncfusion]
Replied On August 28, 2017 12:32 PM UTC

Hi Kevin, 
We were able to reproduce the issue and have logged a defect report regarding this. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates 
Please let me know if you have any questions. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon