Need to display same number in all rows of single column in Pivot Table

[Saro_2306]

Hi All,

I need to display one KPI value number in all rows of single column in Pivot Table

Please can one help me out on this.

Eg: All rows of Column 2 Having same value of 3rd KPI.

KPI Name	Column 1	Column 2
KPI 1	23	56
KPI 2	45	56
KPI 3	56	56
KPI 4	42	56

Thanks in advance

[Kushal_Chawda]

@Saro_2306  what is KPI name and column1?

[Saro_2306]

@Kushal_Chawda 

Column 1 => Sum(Data)

Column 2=> Total SI Value 5365 should be in all  rows.

[Kushal_Chawda]

@Saro_2306  try below expression to display value in all rows

=sum(total {<[Bridge to gap -Bifurcations]={'Total SI'}>}Data)

[Saro_2306]

@Kushal_Chawda  i have tried that expression too, but shows only values in Total SI row, showing 0 in other rows

[Kushal_Chawda · Accepted solution]

@Saro_2306  Not sure how you tried it but 'total' keyword is important there.. total will ignore dimension values and apply same value across dimension

=sum(total {<[Bridge to gap -Bifurcations]={'Total SI'}>}Data)

[Saro_2306]

Thanks for Solution @Kushal_Chawda  Somewhere i missed.