|129343||Mar 14,2017 05:47 AM UTC||Mar 15,2017 01:54 PM UTC||ASP.NET MVC||1|
And I need "1-5-2016" and "1-11-2016" as the column values.
I can access the Items collection of the pivot table field and set the visibility like so:
IPivotTable pivtable = this.Sheet.PivotTables["PivotTable6"];
IPivotField pivfield = pivtable.Fields["Date"];
pivfield.Items.Visible = false;
pivfield.Items.Visible = true;
however I cannot access the Text property of the PivotFieldItem because the IPivotTableFIeld interface only exposes the Visible property and I cannot cast to PivotFieldItem because the class is not exposed.
So how do I determine dynamically which items I need to set to visible?
I would need access to the Text property so I can determine if I need to set Visible to true or false.
Any help would be appreciated,
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.
This page will automatically be redirected to the sign-in page in 10 seconds.