cancel
Showing results for 
Search instead for 
Did you mean: 

Repeating rows in a pivot table

pcahill
7 - Data Storage
7 - Data Storage

it possible to repeat rows in a pivot table instead of having them grouped at the beginning? Thanks

1 REPLY 1

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @pcahill ,

2 methods to achieve this are:

1. If you have 3 fields under Rows panel, create a custom column in table by concatenating those 3 fields and use it as first column in pivot. Then use widget script to replace the values in first column with blank ('') or make the column 0 width

2. Use Aggregated Table plugin : https://www.sisense.com/marketplace/aggregated-table/ 

-Hari