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. Image for the cookie policy date

Something wrong with IPivotField's PivotFilter

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:
salesDateField.PivotFilters.Add(PivotFilterType.ThisYear,salesDateField,null,null);

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.


1 Reply

SS Sridhar Sukumar Syncfusion Team 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. 
  
Regards, 
Sridhar. 


Loader.
Live Chat Icon For mobile
Up arrow icon