Cross Tab divide one column by another

[AJRowe]

SAS Visual Analytics 7.4 Hotfix 09

I'm making a crosstab.  My raw data is a result by 2 categories.  1st data column is an average of the result, 2nd column is a count of the results, 3rd column is a count of results less than a certain value (number of "failures"), 4th column is supposed to be the percentage of the 3rd column/2nd column.  Basically it's a failure percentage.

For the 4th column, i made a calculated item of  (column_2)/(column_3).  But since I'm forced to choose an aggregation for the calculated measured value, I don't get the actual raw percentage calculation. 

In case it matters, I have the report filtered for the current month/year.

How do I set up my 4th column?

[VDD]

Please be kind and provide information need to understand your request.

How to create a data-step version of your data
https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

How to Add attachments
https://communities.sas.com/t5/Community-Memo/Adding-attachments-to-your-communities-posts/ba-p/4647...
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers...

[AJRowe]

I figured out my problem.  I didn't create New Aggregate Measures, I just changed the aggregations of data columns.  When I created new aggregate measures, I was able to get calculate percentages using them like I needed.

Thanks