Data Percentages within a workbook

[UPM85040]

I need to generate a report for tax purposes that calculates the % of records in each zip code contained therein.
Can anyone help with that?

 

[scottsen]

It will depend a bit on the structure of your tables/relationships (if you have any), but it will be something like...

[TotalRecords] := COUNTROWS(MyRecordTable)
[% of Zip] := [TotalRecords] / CALCULATE([TotalRecords], ALL(MyZipTable[ZipCode]))

Assuming you had ZipCode on rows of your pivot table.

 

[UPM85040]

It will depend a bit on the structure of your tables/relationships (if you have any), but it will be something like...

[TotalRecords] := COUNTROWS(MyRecordTable)
[% of Zip] := [TotalRecords] / CALCULATE([TotalRecords], ALL(MyZipTable[ZipCode]))

Assuming you had ZipCode on rows of your pivot table.

Thanks I'll give it a shot

 

[UPM85040]

I showed this to my data guy and he is at a loss as to how to make this happen. Are you aware of a service that would write this program for me? I will have to do this task numerous times per month and would lie to provide someone with a sample mailing file and have them build me a template document from which to work with.

 

[scottsen]

Drop me a line.