Ralph's Page

Is Excel actually lacking a built-in solution for this, or am I just not aware of it?I have a pivot table showing summed $ values from my raw data.  The field in my pivot table is formatted to show no decimal places, i.e., values are displayed rounded to the nearest dollar.  The issue is that the total shown in the pivot table, which of course is also rounded to the nearest dollar, may not always match what you get if you add the rounded row values manually.It's easy to see how this is…See More

I've created an SMI report with a pivot table in the spreadsheet, and set a field called YEAR to be a Column Label in the pivot table.  The values in YEAR are 2011, 2012, and B2012.  The column is formatted as Text in the raw data.  I am setting a filter on the field to display only 2012 and B2012 data.  I then save the template, link it, close it, and rerun the SMI report.  The issue I'm seeing is that when the report runs, the filter has changed so that only 2012 data is shown.  I have to…See More

I am setting up a report using a Container that points to vdvBudgetAnalysis.  This SQL view does not contain any TranDate or PostDate data.  Instead, it contains FiscYear, FiscPer, and FiscYearPer fields.  I don't need TranDate or PostDate data for my report, IF I can find a way to filter the report using these Fisc fields.  I want to include Parameters that will allow the user to select a time range of say, for example, Jan2010 through Jun2011.  Without TranDate or PostDate data, and without…See More