i have few page fields in my pivot table and i am adding this page field as a row field. i am getting an error while trying to do this. Sample code below
pivotTable.DataOnRows = true;
when ever we add a row field which is available in page fields, this same field will be removed from page field and it adds up in the row field and the pivot table gets refreshes. Let me know how to handle this scenario
in EPPlus. In excel dll it can be handled and as epplus is binary data i am not able to find the code for this scenario. Also there is no option for refreshing the data in pivot table with EPPlus dll.
Your help will be appreciated.
Thanks in advance.