Ignore column in pivot table expression

[Florian49000]

Hello,

I want to know how to ignore a column in a pivot table.

For example, when i choose only a dimension (Référence), and i put the following formula :

sum(if(InDayToTime(timestamp(DateTempsPlanif), timestamp(DateHeureFin), 0, timestamp(DateHeureDebut)),DureePlan))

I have :

When i add the column 'Cellule', with the same Dimension and formula, i have :

How can i have the same result as the first table when adding the column 'Cellule' ? (For example, 144 for all columns for HJB 9'' D Renault)

Thanks,

Florian

[brunobertels]

hi may be this 

aggr( nodistinct 

sum(if(InDayToTime(timestamp(DateTempsPlanif), timestamp(DateHeureFin), 0, timestamp(DateHeureDebut)),TOTAL DureePlan))

, Ref 

)

[Florian49000 · Accepted solution]

Thanks ! 

it worked with :

aggr(nodistinct

sum(if(InDayToTime(timestamp(DateTempsPlanif), timestamp(DateHeureFin), 0, timestamp(DateHeureDebut)),TOTAL DureePlan))

,Ref)