wilkies0106aw
New Member
All,
Pretty new to dashboards. My dashboard is one pivot table, with various columns.
I know that if you expand on a value in my pivot table, it drills down and you can see what is behind the value on a separate worksheet.
Can you get the drill down to happen automatically?
I have a worksheet which contains all my raw data. Other worksheets are various Pivot table views.
The raw data is connected to a SharePoint list. One of the columns on the raw data sheet (name) is a hyperlink to a SharePoint document (image it's a webpage or to a file on a network). Although the url is clickable on the raw data, every drill down strips the click-ability out.
You mind be able to think of it as, Sales By Employee, when you filter by employee name and you want to see the detail of the sales.
Thanks
W
Pretty new to dashboards. My dashboard is one pivot table, with various columns.
I know that if you expand on a value in my pivot table, it drills down and you can see what is behind the value on a separate worksheet.
Can you get the drill down to happen automatically?
I have a worksheet which contains all my raw data. Other worksheets are various Pivot table views.
The raw data is connected to a SharePoint list. One of the columns on the raw data sheet (name) is a hyperlink to a SharePoint document (image it's a webpage or to a file on a network). Although the url is clickable on the raw data, every drill down strips the click-ability out.
You mind be able to think of it as, Sales By Employee, when you filter by employee name and you want to see the detail of the sales.
Thanks
W