How to Repeat Row Labels in a Pivot Table

Is it possible to have the pivot table’s row label repeated to avoid large empty space (audience have to scroll down to see the label/name

Hi @jjc -

For tables you can concatenate field names and then hide the column. However, that does not currently work for pivot tables.

Here is a workaround for pivot tables.
Note: You will lose the ability to sort and will have to use controls to restore functionality.

1. Create parameters/controls for your desired sort value and sort order

2. Create a calculated field to switch the sort value based on the parameter

c_sort_value

ifelse(${sortparameter}='Sales',Sales,Profit)

3. Create a calculated field to sumOver the rows used in your pivot table.

c_sumover

sumOver({c_sort_value},[concat(Category,{Product Name})],PRE_AGG)

4. Create a calculated field to denserank your rows by your sort value

c_row

ifelse(${order}='ASC',denserank([{c_sumover} ASC],[],PRE_AGG),denserank([{c_sumover} DESC],[],PRE_AGG))

Final result:

1 Like