Table

[Anonymous]

good afternoon

They could help??

Can you use an expression as dimension in a pivot table?

this is the expression that I need to use as dimension

=(if(sum( {<CANAL={'2CAN'},SEMANA={'Lunes','Martes','Miércoles','Jueves','Viernes'},NOMBRE_MES={$(vMes)}>}CAPACIDAD_14MIN)=0

  ,

  null(),

  sum( {<CANAL={'2CAN'},SEMANA={'Lunes','Martes','Miércoles','Jueves','Viernes'},NOMBRE_MES={$(vMes)}>}CAPACIDAD_14MIN)))/5

Thank you

[sunny_talwar]

Should be possible:

Calculated Dimensions