Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a list box (attached).
The filter has to be single selection (as we are using the filter values to pass through URL and can only take one dimension value not multiple).
Now the requirement is to have another dimension value as 'ALL' in this filter selecting which the user has data pertaining to other 3 dimension values in pivot table.
Question - Can we achieve this using Set Analysis? I mean can I create another column which includes 'ALL' and remaining dimension values of [Fault Level]. If yes, please help me with the formula. Or give a fair idea about how to achieve this.
Hi,
Please check the attachment, is this what you are looking for?