Hi,
I am posting a link to a spreadsheet, In sheet1 I have a lot of raw data, and there is a corresponding pivot table in the sheet2.
What I am in need of now is, in the pivot table i need to omit the results of server name which are present in only one RFC,
In other words I need the data of only the server names which is present in two or more RFC. Is there anyway of doing that in the pivot
table itself or you can guide me on that.
I have highlighted some server in yellow for your reference.
The output can be in the same format as pivot table looks.
And, really you will be saving my lot of work time if this can be achieved.
Thanks in advance
Link:
http://www.box.net/shared/s72qe5tncvrr52r2bafg
I am posting a link to a spreadsheet, In sheet1 I have a lot of raw data, and there is a corresponding pivot table in the sheet2.
What I am in need of now is, in the pivot table i need to omit the results of server name which are present in only one RFC,
In other words I need the data of only the server names which is present in two or more RFC. Is there anyway of doing that in the pivot
table itself or you can guide me on that.
I have highlighted some server in yellow for your reference.
The output can be in the same format as pivot table looks.
And, really you will be saving my lot of work time if this can be achieved.
Thanks in advance
Link:
http://www.box.net/shared/s72qe5tncvrr52r2bafg