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 |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |