This isn't a really tough one I guess, but I am not able figure out how to do this as I am not an excel expert. I need to create a Pivot which looks like the table in the "Requirement" tab of the excel sheet uploaded on the below link
[login to view URL]
I managed to add my Pivot table in the "Data and Pivot" tab, but I am struck at the below step - request you to help.
Adding "% pending" column as an additional column
Note that I tried "Calculated Field" option, but since the "Completed" and "Pending" columns in the Pivot are not the actual columns themselves but are column cell values represented as columns, I am not able to add the "% Pending" column as "Calculated Field"
I am able to "Show Value as" "% Row Total" But I need this percentage only for the % pending column and not all columns along with the "Pending" column which has value as well.
Note that The pivot table has to be updated after refresh if and when the data changes and new lines are added or deleted.
Also I would like to understand and learn the solution as well once the problem is solved and requirement is met.
Appreciate any help here !
18 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹737
Hi there..i have read your project and understood your requirement..i am an expert in excel..will do this project for you in half an hour.. thanks
HELLO, MYSELF Manish Kumar Nigam. I’M A PROFESSIONAL DATA ENTRY EXPERT. I WILL PROVIDE YOU WITH HIGH-QUALITY SERVICES IN REASONABLE DELIVERY TIME. FEEL FREE TO CONTACT ME AT ANY TIME. LOOKING FORWARD TO YOUR RESPONSE.
I am always honoest towards my work. I have a long experience of working on computer. I have done a lot of work in MS Word and MS Excel. I am interested in your project.
Hi! I would like to help you with your requirement. And I can assure you fast and accurate delivery. Please let me know if you are interested. Thanks.