Hi everyone!
I have a problem and I don’t know how to solve it
If “variedad”, “Bloque” and “fecha” are the same
I have to unify the two rows but adding the values of “cantidad”
Getting a row with:
“Variedad”=Spider Yellow Sol
“Bloque”=11
“Fecha”=2.5.2021
“cantidad”=30+50=80
as a result i could display this information in a unified way
Getting just one entry in calendar view:
Spider Yellow Sol BLQ: 11 Cantidad: 80
Thank you!
Solved! Go to Solution.
Please
create a column called say [VariedadBloqueFecha] with an expression
CONCATENATE([Variedad], “-”,[Bloque],"-",[Fecha])
Create a slice called say " SelectedParameters" with a filter expression
[Key Column]= MAXROW( FILTER(“Table Name”, ( [VariedadBloqueFecha]=[_THISROW].[VariedadBloqueFecha])), [_ROWNUMBER])
Create a VC with an expression (This will be an expensive VC and possibly could be replaced by a real column updated by reference action that executes on a form save)
CONCATENATE([Variedad], " BLQ: ",[Bloque],"Cantidad: ", SELECT ( Table Name[Cantidad], [VariedadBloqueFecha]=[_THISROW].[ [VariedadBloqueFecha]))
Use the slice in step 2 as input to the calendar view and use the VC in step 3 as description in that calendar view.
Try this instead:
(
[Id Corte]
= ANY(
ORDERBY(
FILTER(
“Proyeccion de Corte”,
([VariedadBloqueFecha] = [_THISROW].[VariedadBloqueFecha])
),
[_ROWNUMBER],
TRUE
)
)
)
Steve,
it worked perfectly
Thank you very much!
User | Count |
---|---|
40 | |
29 | |
24 | |
24 | |
13 |