Hi Techies,

I am getting one error in "Filter the Chart Web Part based on begin and end date" example, the error is:


"An error occured during the web part rendering. The error was: Pivot processing failed during: Phase: Processing Pivot - Data Matrix - Properties, Action: Parsing - =SUM(Fields!Value1.Value). Error was: The Fields!Value1.Value is not a valid reference. The Value1 is not a name of a data set field."

please help me.

Thanks & Regards

Raju Ganga

Hello Raju,
Please note that the KB topic is using sample data. You need to check what are the column names from your data source.

For example, if you are using “Company X” and “Company Y”, your expressions should look like this:
=SUM(Fields!Company_X.Value)

Let us know if you meet any problems.

Best Regards,
Nevron Support Team