Forum Discussion

Copper Contributor

Aug 23, 2020

Calculate percentage from a single Pivot Cell

Doing some option trading and trying to analyze the data better. As part of this I'm trying to aggregate my Win/Loss percentage across days, weeks, months, strategies, etc.. I have put together...

excel

Formulas and Functions

office 365

PatAzz

Copper Contributor

Aug 24, 2020

PatAzz

No replies yet but I have a couple of ideas.

I've added two columns in my source sheet (one for Wins, one for Losses) but I can't figure out the syntax for a calculated field.

"Count of Adj W/L" / "Count of Adj Wins"

Any help would be appreciated

Pat