Currently we have this option local to work sheet to "Repeat members " ( show duplicates )and the user needs to take the pain to go and select the option in the "crosstab" . Having a option to default "Repeat Members" and being able to control the settings of the workbook in "Global settings" is one option which we are looking . Is there a possibility to default Repeat members before opening the report (Ex: Like a global setting)? Also could you please specify where we can see the Global settings for the Analysis too?
Yes I need like a default setting , is a users request that always the option repeat members should be active. and every time that they enter to the pivot table the option show all the columns with that option Thanks. Claudia.
unfortunately no registry parameter exists for 1.4.x 😞
But according to this "idea": Hide Repeated Key Values AAO : View Idea it should be checked by default from version 2.0 onwards (comment by Peter Alexander, Dec 8, 2014)
I tried to add "repeat members" in the ribbon tab but don't work another point we use office 365 and I don't find crosstab option .. In my understanding doesn't exist another quick option , the user should select the check box
Claudia - have you tried making this setting in a default workbook, and then when users open a new workbook with the default workbook, the setting is there?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.