cancel
Showing results for 
Search instead for 
Did you mean: 

Showing X Number of Columns

amelia
10 - ETL
10 - ETL

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 2

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @amelia ,

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

harikm007_1-1662052057755.png

 

-Hari

 

Hi Hari, thanks so much! This worked.