djemy1975
11-22-2018, 01:32 PM
Dear firends,
I have 3 sheets from which I have made pivot tables and charts as percentage of projects closing progress for 3 types of projects:"Basic to sustain","specific to sustain" and "improve-performance".I succeeded in doing so far.
Now,I want to display percentage of progress of each project BY CODE as shown above depending on the difference between total booking and appropriation in my sheets
Approp. is in column G
Total Booking is in column BG
Reste à faire is in column AS
Is this kind of sorting possible?
Attached a sample of data
Best regards,
I have 3 sheets from which I have made pivot tables and charts as percentage of projects closing progress for 3 types of projects:"Basic to sustain","specific to sustain" and "improve-performance".I succeeded in doing so far.
Now,I want to display percentage of progress of each project BY CODE as shown above depending on the difference between total booking and appropriation in my sheets
Approp. is in column G
Total Booking is in column BG
Reste à faire is in column AS
Is this kind of sorting possible?
Attached a sample of data
Best regards,