After using the following property in customize JTD widget script for Pivot widget, JTD is enabled for all rows.
drillToDashboardNavigateTypePivot: 1
It would be great if we have an option of en...
hey Pushpanjali_J ,
I'm not able to see a screenshot but it's sounds like you have a Pivot table with 4 Dimensions(Rows) and 2 Measures, and the need is to be able to drill from a Measure but only include 1 or partial Dimension as a Filter in the drill dashboard
Here as Example
The following is achievable using a Widget Script. Please review the following Community article
The Script Exclude the selected filters from the Drill Dashboard.
prism.jumpToDashboard(widget, {
excludeFilterDims: ["[DimProducts.Color]","[DimCountries.Region]","[DimCountries.CountryName]"] //update the list according to the filters in a format of table_name.column_name
});Drill include Widget Script - only Color filter applied
Drill without the Widget Script - all rows applied
Best Regards