Jumat, 05 Juli 2013

[ExcelVBA] Re: Calculated Fields & Pivot Tables

 

Darren, I want to be sure that I understand. Do you simply want a line by line percentage? I think that maybe you are wanting an accumulated percentage instead, but I want to be sure that I know what you are asking.

For example:
Line by line
6 3 50%
10 4 40%

--- In ExcelVBA@yahoogroups.com, "darren" <darrenlshipley@...> wrote:
>
> I have two columns. One is the total# of projects and next to that is the # of those projects that have completed. I would like to add a column that calculates the % of the pivot data in each row of those columns to show me the % of each total # of projects that have completed.
>
> Is this possible?
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar