Skip to Content
0

Calculate Percentage of column value in cross tab

Mar 08 at 07:47 PM

27

avatar image

Created a cross tab that includes the counts of an item by the item type. The cross tab has a sum value by row (location) for each item type.

Count % type1 type 2 type 3 total

loc 1 24 37.5 2 3 4 9

loc 2 35 14.28 1 1 3 5

How to capture the percentage for as an example Type 2? Result would be 12.5 (3/24).

Both Count and % are variables. The % is the total / count.

Get a #multivalue for rows that have values in more than one column.

Thoughts?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Webi User Mar 09 at 01:57 PM
0

I figured this out. Revised the variable to include the =Sum( before the if statement. Cross Tab is showing the correct calculation now.

Share
10 |10000 characters needed characters left characters exceeded