I have source data that shows 3 paths (Path 1, 2, 3), yet when it displays percentages, I only want the pivot table to reflect percentages for only Path 1 and 2. I can hide path 3, but the percentages still count the path 3 numbers.
How can I solve this? *See attachment
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…