count elements by pareto class

[#1]

hi,

i have created a pivot table that represents pareto class. i would count elements belonging in a-class and elements belonging in b-class. After that put the number in a text box. Have you got any idea  ? which formula do i use ?  thanks

[tresesco]

May be like:

=Count( {<[Pareto Class]={'A'}>}YourField)

=Count( {<[Pareto Class]={'B'}>}YourField)

'Distinct' keyword is upto your requirement.

[#3]

THANKS for the reply. as you can see from the attached image i am trying to insert the formula you suggested me, but, in the blue textbox on the left it returns zero as result. It seems it does not recognize the field. Is it correct the sintax ? How do i change the formula ?

The analysis of pareto is on the right into straight table.

thank you very much

[tresesco]

You are right Daniele,

DANIELE ZECCHETTO wrote:

..... It seems it does not recognize the field. ....

and you would be the right person to tell the right field name.

[nenadvukovic]

Hi, I have a similar problem of not being able to get the count of items by dynamically created classes (Is it possible at all to get a summary table?)

Were you able to get it? Thx

[nenadvukovic]

If you do not have the [Pareto Class] available in your data model, and I believe you do not as you want to have this to be dynamic, you can't use expressions outside the table.

Here is how I sorted out a similar issue to enable users to get this totals by classes calculated automatically and dynamically.