Harry Flashman
Active Member
- Joined
- May 1, 2011
- Messages
- 361
Is there a property that returns the name of the selected pivot item in a pivot field (especially a page field)?
Or do I need to loop through every pivot item and check its visible status?
In my case the page field is a selected month such as "January 2021". Sometime more than one month will be selected in which case the pivot table will display "(Multiple Items") or "(All)". Whatever the page field shows as being select I would like to return that value.
Any assistance would be greatly appreciated.
Or do I need to loop through every pivot item and check its visible status?
In my case the page field is a selected month such as "January 2021". Sometime more than one month will be selected in which case the pivot table will display "(Multiple Items") or "(All)". Whatever the page field shows as being select I would like to return that value.
Any assistance would be greatly appreciated.