Unified rows

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!

Please

  1. create a column called say [VariedadBloqueFecha] with an expression
    CONCATENATE([Variedad], “-”,[Bloque],"-",[Fecha])

  2. Create a slice called say " SelectedParameters" with a filter expression
    [Key Column]= MAXROW( FILTER(“Table Name”, ( [VariedadBloqueFecha]=[_THISROW].[VariedadBloqueFecha])), [_ROWNUMBER])

  3. 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.

3 Likes

Suvrutt Gurjar Thank you very much!

i have one doubt.
when I enter the formula in the slice it shows me this error, how can I solve it?
sorry, i’m pretty new using this tool :sweat_smile:

1 Like

Try this instead:

(
  [Id Corte]
  = ANY(
    ORDERBY(
      FILTER(
        “Proyeccion de Corte”,
        ([VariedadBloqueFecha] = [_THISROW].[VariedadBloqueFecha])
      ),
      [_ROWNUMBER],
        TRUE
    )
  )
)
2 Likes

Steve,
it worked perfectly
Thank you very much!

2 Likes