Fermé

Excel Pivot Table Automation

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 !

Compétences : Excel, Visual Basic, Traitement de Données

Concernant l'employeur :
( 0 commentaires ) Hyderabad, India

Nº du projet : #32691837

18 freelances font une offre moyenne de 737 ₹ pour ce travail

rohitagarberg

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(424 Commentaires)
6.7
merinsinha

Excel pivot table Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(121 Commentaires)
5.5
PERPETUAL0

Hello there i have done top excel Pivot dashabords let me share some samples regards ILYAS

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(81 Commentaires)
5.3
Leozida

Hi There, Hope you are doing well, Interested in your posting as I’m used to performing such projects (See Profile). I’m ready to send you the solution right away if you give me a chance. it can be done by adding a hid Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(21 Commentaires)
3.6
srikanta0211

sir i am excel expert, i can help you on your work. you can contact me for more details. i know hindi english and bengali.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(5 Commentaires)
3.0
adesoqi

Greetings, I have 20+ experienced years in MS Office , with more than 1000 Excel sheets & workbooks I read your project, and I can do ISA

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(3 Commentaires)
1.7
vincus86

Hello. I have downloaded the file and already created the data for you. If you need it, please let me know. Thank you Silvy

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(1 Évaluation)
0.3
manishnigam1988

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
RAVIK882622

I AM A DATA ENTRY EXPERT . I HAVE ONE YEAR EXPERIENCE OF DATA ENTRY . I PROVID GOOD PERFORMENCE IN YOUR WORK.THANKS.,,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(0 Commentaires)
0.0
howrahSHIKSHA

i am a very honest and hard working parson. i have compleated many such projects . t find you project very challanging .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
Sairathodpalsud

I am Excel expect and I am professionally work in.I am Excel expect and I am professionally work in.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
srisucess

Will give you excellent output for the data for you as per the requirement. Please share the details

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
sushil121960

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
mamedovr

Hello. I prepared this file And I can send you this file Please write me and I just send the file to you Regards Rahim

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
sbala26

Hi I understand your requirement for a pivot table and understand it. I am certified in Microsoft Excel. I can resolve this problem. I think you have a pivot table with data in 1st sheet. As per your requirement, it Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
hasaralevesque

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
HunterMcCarthy

This is very simple I can have it done in about 5 minutes.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
rupalgupta90

Hi sir, As I am certified Advance Excel by which have the good knowledge of a the concept. So,looking forward to hp you out.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0