Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiply a field value in pivot table

Hi everybody, I need to multiply the row value of a field in a pivot table,

In my table "Máquina (Estructuras)" I need to get te multiply of the field "componentes unicos" count with the field "Texto componente".

I tryed for some ways but I can´t make it. Could you guys help me?

I attached the app

I appreciate your time.

3 Replies
Not applicable
Author

It seems to be working when I looked at it. With the selections that are made on open (What you saved with) all values available for the field "componentes unicos" are 1. If you change the selection and create another expression without this multiplication  you can see the change

Not applicable
Author

well, if you select in Field "Texto Componente" you can see that the value in"Conos" is 0.01, but I have 3 rows, what I need is to multiply the value "Conos" by the number of rows in the field "Componentes Unicos".

I can´t get the multiplication.

Not applicable
Author

Oh all right. You want the count of the rows multiplied by Cronos not the value of the rows.

Try using the total and distinct qualifiers like this:

count(Distinct Total [Field])