Subclassifications

[gr_eldred]

Good morning I have a problem with a set analysis I need to get the same subclassifications that are in the table on the left.

The first table is the sales calculation so far this quarter.

The second table is the inventory calculation, it is normal to have different subclassifications. I just need to show the same subclassifications in the second table. I tried with an if that is as follows:

=

if(

sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Especial Numerico], %Tipo_Dato = {'Inventario'} ,[Año Apple], [Mes Apple], [SemanaAppleEspecial], Almacen_Tipo_M = {'Facturación'} >}Existencia)+ //IOH

sum({<  Ship_Status = {'In-Transit', 'Uplift','Shipment Picked Up' },  OC_Status_Articulo -= {'R'} >}Ship_Enviado)+   //OCIT

Num(sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Apple],[Año Apple], [Mes Apple], [SemanaAppleEspecial], %Tipo_Dato = {'Traspaso'}, Tra_Status={'Pendiente'}  >}Tra_Faltante) )+ //Traspaso

(sum(Total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} ,  [Año Apple], [Mes Apple], [SemanaAppleEspecial],  Mes,  semana, Trimestre >}OR_Cantidad_recibida) - sum(total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} ,  [Año Apple], [Mes Apple], [SemanaAppleEspecial],  Mes,  semana, [Trimestre Especial Numerico], com_num_folio ={'*'}-{''}  >}OR_Cantidad_recibida))//IPE

>0,

num(sum({$<Status-={'C'},  Clasificación -={'Servicios','Refacciones','Pagos*','*Core value*'}, [Año Apple]={$(V_Año_Actual)} ,[Trimestre Especial Numerico]={$(v_MaxTrimestreActual)}, SemanaAppleEspecial= {"<=$(v_MaxSemanaEsp)"}>} Cantidad_I)),

num(sum({$<Status-={'C'},  Clasificación -={'Servicios','Refacciones','Pagos*','*Core value*'}, [Año Apple]={$(V_Año_Actual)} ,[Trimestre Especial Numerico]={$(v_MaxTrimestreActual)}, SemanaAppleEspecial= {"<=$(v_MaxSemanaEsp)"}>} Cantidad_I))

)

What is in bold is equivalent to the IOHT column of the second table.

I need the table rankings on the right to have the table on the left

[rubenmarin1]

Hi Eldred, seems related to those groups that doesn't have data, have you unchecked the option to 'Supress zero values' in the presentation tab of the second table?

Also, what's the difference between the 'true' and 'false' part of the 'If'?

[gr_eldred]

Hola Ruben no hay diferencia entre el si y el no, si esta desmarcada la opcion de suprimir valores en cero solo que aun me sigue apareciendo mas de un lado las clasificaciones.

Lado izquierdo es ventas, lado derecho es inventario necesario mostrar la misma cantidad de subclasificaciones que se ven en la tabla derecha

[gr_eldred]

Hi Ruben there is no difference between the yes and the no, if it is clear the option to delete values in zero only that I still continue to appear more than one side the classifications.

Left side is sales, right side is inventory I need to show the same amount of subclasses that are seen in the right table

[gr_eldred]

For example, it should not appear in table 1 because I do not have it in the second table of inventories and also had no sales.

The other in the table on the left I am using the dimension of weeks and in the other I bring all unfiltered weeks

[rubenmarin1]

So the left table is the one that has to be changed?

In this case it can be done cheking that 'Zupress zero values' in the left table.

Or maybe with a dynamic dimension like:

aggr(

if(

sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Especial Numerico], %Tipo_Dato = {'Inventario'} ,[Año Apple], [Mes Apple], [SemanaAppleEspecial], Almacen_Tipo_M = {'Facturación'} >}Existencia)+ //IOH

sum({<  Ship_Status = {'In-Transit', 'Uplift','Shipment Picked Up' },  OC_Status_Articulo -= {'R'} >}Ship_Enviado)+   //OCIT

Num(sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Apple],[Año Apple], [Mes Apple], [SemanaAppleEspecial], %Tipo_Dato = {'Traspaso'}, Tra_Status={'Pendiente'}  >}Tra_Faltante) )+ //Traspaso

(sum(Total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} ,  [Año Apple], [Mes Apple], [SemanaAppleEspecial],  Mes,  semana, Trimestre >}OR_Cantidad_recibida) - sum(total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} ,  [Año Apple], [Mes Apple], [SemanaAppleEspecial],  Mes,  semana, [Trimestre Especial Numerico], com_num_folio ={'*'}-{''}  >}OR_Cantidad_recibida))//IPE

>0, Subclassification, Subclassification)

[gr_eldred]

Try this one but I still have no success.

if(

sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Especial Numerico], %Tipo_Dato = {'Inventario'} ,[Año Apple], [Mes Apple], [SemanaAppleEspecial], Almacen_Tipo_M = {'Facturación'} >}Existencia)>0  //IOH

or sum({<  Ship_Status = {'In-Transit', 'Uplift','Shipment Picked Up' },  OC_Status_Articulo -= {'R'} >}Ship_Enviado)>0    //OCIT

or Num(sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Apple],[Año Apple], [Mes Apple], [SemanaAppleEspecial], %Tipo_Dato = {'Traspaso'}, Tra_Status={'Pendiente'}  >}Tra_Faltante) )>0 //Traspaso

or (sum(Total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} ,  [Año Apple], [Mes Apple], [SemanaAppleEspecial],  [Trimestre Especial Numerico] >}OR_Cantidad_recibida) - sum(total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} ,  [Año Apple], [Mes Apple], [SemanaAppleEspecial],  [Trimestre Especial Numerico], com_num_folio ={'*'}-{''}  >}OR_Cantidad_recibida))>0//IPE

,

num(sum({$<Status-={'C'},  Clasificación -={'Servicios','Refacciones','Pagos*','*Core value*'}, [Año Apple]={$(V_Año_Actual)} ,[Trimestre Especial Numerico]={$(v_MaxTrimestreActual)}, SemanaAppleEspecial= {"<=$(v_MaxSemanaEsp)"}>} Cantidad_I))

)

Appear more weeks and the CTO subclassification that should not appear (have a more subclassification of the left side)

[gr_eldred]

If I remove the zeros it will eliminate what did not have sales but if it has inventory

[rubenmarin1]

And using the dynamic dimension?