Skip to main content
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Search instead for
Did you mean:
Contributor II

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

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

Labels (3)

• ### Set Analysis

1 Solution

Accepted Solutions

@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)

6 Replies

@Saro_2306  what is KPI name and column1?

Contributor II
Author

Column 1 => Sum(Data)

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

@Saro_2306  try below expression to display value in all rows

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

Contributor II
Author

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

@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)

Contributor II
Author

Thanks for Solution @Kushal_Chawda  Somewhere i missed.

Tags
Community Browser