how to add a manual column in pivot table

tauceef9 — Tue, 01 May 2018 07:28:39 GMT

Hello Friends,

I am creating a pivot table where I have one column "SLA Description" in Rows section with below code:

=ValueList('Demand ASA','First Tier Resolution','Incident P1 Response Critical')

with that a month column and a measure using pick(match()) function.

I want to add one more column under Rows "SLA Threshold" using below code:

=Pick(Match(ValueList('Demand ASA','First Tier Resolution','Incident P1 Response Critical')

,'Demand ASA','First Tier Resolution','Incident P1 Response Critical'),

Col1,Col2,Col3)

but it is not displaying anything. Col1,2,3 values are coming directly from a excel file.

My ultimate aim is below table:

Any help would be great.

Regards,

Tauceef

Re: how to add a manual column in pivot table

tauceef9 — Wed, 02 May 2018 08:12:24 GMT

Have solved the issue by creating a temporary table using inline load for "SLA Description" values and used this in "IF" condition to create "SLA Threshold" column, that way it works.

Regards,

Tauceef

topic how to add a manual column in pivot table in App Development

how to add a manual column in pivot table

Re: how to add a manual column in pivot table