Multiple field with count in one table

[xiuur2508]

Hello,

So i have multiple field (Field1, Field2, Field3,... ). Each fild contain the same data. ( Value1, Value2, Value3,... )

I need to count each values.

Like:

Data	Field1	Field2	Field3
Value1	Count(field1)	Count(field2)	Count(field3)
Value2	Count(field1)	Count(field2)	Count(field3)
Value3	Count(field1)	Count(field2)	Count(field3)
Value4	Count(field1)	Count(field2)	Count(field3)
Value5	Count(field1)	Count(field2)	Count(field3)

How can i archive that ? With aggr()?

Thanks a lot

[sunny_talwar]

Not sure I understand your data... you have expressions in the fields?

[Anil_Babu_Samineni]

I am with sunny

OR

Create Straight Table

Dimension - Data

Expressions - Count(Field1), Count(Field2), Count(Field3) // Three expressions

[xiuur2508]

OK i will try to explain better ^^

I want to have the frequency of each values in eaach field.

Field1:                                  Field2:

sun     5       50%                  sun     11       55%       
star     4       40%                  star     2       20%
Moon  1    10%                     Moon  7      35%

I don't want to have multi field.
I want one table with all the field with frequency and percent. To extract all in excel in one time.

It's the same value in each field ( sun, star, moon, ... )

[PrashantSangle]

Hi,

Right Click on list box > property> general  > Show Frequency > (If required in percent then select %)

If you required all 3 then

list box > property > Expression >

Add expression

1: count(FieldName)

2: sum(FieldName)/Sum(Total FieldName)

Regards,