Forum Discussion

pcahill's avatar
pcahill
Data Storage
09-01-2022

Repeating rows in a pivot table

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

1 Reply

Replies have been turned off for this discussion
  • harikm007's avatar
    harikm007
    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