Forum Discussion

amelia's avatar
09-01-2022

Showing X Number of Columns

I have several columns in my Sisense pivot table widget since I'm using dates as a column. However, since Sisense limits up to 73 rows. Instead of the first 73 rows, I would like to get the last 73 rows. Can anyone help out with how I can do that? Thanks!

2 Replies

Replies have been turned off for this discussion
  • harikm007's avatar
    harikm007
    Data Warehouse

    Hi amelia ,

    One approach is - add filter on Date field to display TOP 73 days by max([days in Date])

     

    -Hari

     

    • amelia's avatar
      amelia
      ETL

      Hi Hari, thanks so much! This worked.