Forum Discussion
Solved
Pivot Table - Add Column to Calculate Percent Sold
I have a spreadsheet with all of my companies accounts in Sales Force from the past year, both sold and unsold organized by zip code. The main purpose of what I'm using this for is to help better di...
Instead of using implicit measures you may add explicit DAX measures as
Sold:=CALCULATE(COUNTROWS(Range),Range[Sale Status]="Sold") Unsold:=CALCULATE(COUNTROWS(Range),Range[Sale Status]="Unsold") Total:=[Sold] + [Unsold]and use them in PivotTable
If you're willing to do away with the grand totals, you can use a calculated item =Sold/(Sold+Unsold).
See the attached version.