Hi All ,
We have setup a master project portfolio dashboard (master sheet ) which is fed by multiple sheets (Child ) . The calculation for the dashboard is done via a calculation sheet as shown in the attachment . The on click function in the dashboard opens a report showing high priority projects for instance .
The issue we have is that the report that the on click function opens has duplicate columns . So if we have a column called assigned to that is fed by the child sheets , we have 3x the same assigned to columns appearing in the report
Any assistance would be much appreciated


