Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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])