I have a dashboard page with multiple pivot tables on it, and use the drilldown feature to my advantage to view the details of the pivot table upon double-clicking the total.
However, the entire table of source data shows up everytime i double click it, and a lot of unnecessary data that clutters the view. Is there a way with code to limit the view upon the drilldown to only the part number column, description column and related qty column, instead of viewing every single other column?
However, the entire table of source data shows up everytime i double click it, and a lot of unnecessary data that clutters the view. Is there a way with code to limit the view upon the drilldown to only the part number column, description column and related qty column, instead of viewing every single other column?
