How to avoid duplicate rows in BLOX pivot

Hi Srav_Sense ,

Please try this script

            "data": {
                "dashboardId": " ",
                "args": {
                    "displayDashboardsPane": true,
                    "displayFilterPane": true,
                    "mergeTargetDashboardFilters": true,
                    "resetDashFilterAfterJTD": true,
                    "drilledDashboardDisplayType": 3,
                    "excludeFilterDims": [
                        "[Bands.employee_status]"
                    ]
                }
            }

Thanks

Sijo

Hi Sijo1995 ,

Thank you so much for your reply. The JTD looks okay but the data in the main table (BLOX pivot) has duplicate values.

I am using the code from here for BLOX pivot - BLOX WIDGET: PIVOT INSIDE A PIVOT - Sisense Community

Thank you!

Sijo1995 Just wanted to say, we would like to display distinct rows on the main pivot table. 

Hi Srav_Sense ,

Please try Rank() function to remove duplicate value.

Thanks

Sijo