Help me to add the expression to the straight table?

[durgabhavani]

Hi All,

Please help me to add the expression to get the percentage of the categories column. This percentage should be the % of the total categories. Example provided below.

Current output

Categories	NoOfCategories (Count of ID)
IT1	3
ID2	5
ITE3	6
ITM4	7
ITR5	8
LM4	3

Expected Output:

Expected Output
Categories	NoOfCategories (Count of ID)	%OfCategories
IT1	3	9.30%
ID2	5	15.60%
ITE3	6	18.75%
ITM4	7	21.87%
ITR5	8	25.00%
LM4	3	9.37%

Example:

NoOfCategories by Total NoOfCategories (3/32*100)=9.30%

Thanks,

Durga

[olivierrobin]

hello

use a crosstable and this as expression

sum(b)/sum(total b)

(assuming b is the name of your column)

[olivierrobin]

it xorks also with a straight table

[durgabhavani]

Thanks for response Olivier.

I am using pivot table. current existing column expression is (Count(distinct id)), using count function not sum function. if i am changing the count function to sum then my existing column logic is changing. Also note that if I am applying the above logic i am not getting the expected results. (getting '-' in column). Please advice.

[olivierrobin]

use

count()/count( distinct TOTAL)

cf documentation

Count() is used to aggregate the number of values, text and numeric, in each chart dimension