Log In
Register
Home
March 8, 2021
Offline
Good morning,
I get a Pivot Table every few days. My question to you is about 'Show Details' or Duble Click Field. In my case let us say that This Field 'Z' shows number 3 and now if I double click on it or click on Show Details, I need to find out 2 different types of numbers. Let us say if there is a, b, c then the number is 3 (1+1+1)and if it is f,g,h then it is 0(0+0+0) (Meaning some letters I have to count and add them and others have no value just zero) How do I get these 2 values without drilling down for every record. I have 100's of records, it is going to be time-consuming. Is there any way I see these numbers in the pivot table only and not by drilling?
Any advice, Please?
Thanks,
Peace
July 16, 2010
Offline
Hi and welcome to our forum!
Can you please provide a sample file as I'm struggling to visualise the issue. You can just create a small set of dummy data rather than the file with 100s of records.
Thanks,
Mynda
March 8, 2021
Offline
Hello Mynda,
Thank you! I attached a screenshot. Hope that this will be helpful. This is one of the reports out of many reports from the Dashboard.
Thanks,
Peace
July 16, 2010
Offline
Please provide a sample Excel file with some dummy data/extract of your data that illustrates the problem.
Thanks,
Mynda
March 8, 2021
Offline
Hello Mynda,
Thank you! I can't use the extract of my data. I tried to show you in the screenshot. It didn't allow me to edit the file so I am attaching it again.
If it is still confusing and not clear then please let me know so that I don't expect a solution.
Thanks,
Peace
July 16, 2010
Offline
The problem is the screenshot doesn't illustrate the structure of the underlying data. What people usually do when they can't share their data is to create a dummy set of data or anonymise their data so that they can share a file. We don't need your whole dataset, just enough rows to illustrate the issue.
Mynda
1 Guest(s)
