public void TC035_39_40_41_VerifyDownloadGridFunctionlityAndThatTotalSummaryResultInPivotTableShouldBeAccurate(String Bname)
        {
            TestFixtureSetUp(Bname, "TC035_39_40_41-Verify Download Grid Functionlity And That Total summary result in pivot table should be accurate");
            try
            {
                loginPage.navigateToLoginPage().VerifyLoginPageScreenInDetail();
                loginPage.loginUsingValidEmailIdAndPassword();

                homePage.newVerifyHomePage();
                homePage.VerifyAccountOrSwitchIfRequired("QA Testing - Brand Canada");
                homePage.selectOptionFromSideNavigationBar("Print Report by Media");
                charts.VerifyPivotTable();
                pivotGrid.VerifyPivotOptionsPopup();
                pivotGrid.select_deselectOptionFromPivotOptionsPopup("Show Summary Totals");
                pivotGrid.clickButtonOnPivotOptionsPopup("Apply");
                pivotGrid.VerifyPivotOptionsPopup(false);
                charts.VerifyPivotTable();
                string[] columnNames = pivotGrid.readColumnNamesFromPivotGrid();
                pivotGrid.VerifySummaryTotalRowInPivotGrid(columnNames);
                string[,] dataGrid = charts.captureDataFromPivotTable();
                charts.choosePivotBulkActionsForDataFromPivotTable("Download Grid");
                string fileName = brandDashboard.VerifyFileDownloadedOrNotOnScreen("brand_canada_-_media_spend-pivot", "*.xlsx");
                charts.VerifyDataFromPivotTableInExportedExcelFile(fileName, dataGrid);
                pivotGrid.VerifyColumnwiseSummaryTotalInExportedPivotData(fileName);
            }
            catch (Exception e)
            {
                Logging.LogStop(this.driver, test, e, MethodBase.GetCurrentMethod(), Bname + "_TestSuite09_Reskin_PivotGrid_TC035_39_40_41");
                throw;
            }
            driver.Quit();
        }