My Requirement : i was took LOB field in my list box like coloums boxes and pens and another list box is products like coloums A,B,C. Now i am click on pens then we have to show answer is LIfe of business(LOB) then what to do. here don't take the text boxes and don't do the rename the coloum.
When i have done in script as renaming field. automatically data disturbed first pivot table data will not show data then automatically goto second pivot table.
Any condition on current selection box layout. or is it possible or not?