Integrated Financials
 Tablix2 (Tablix)
  Properties
Property Value
DataSetName PercentageSpendingCurrentFY_Query
Top
Height 1.25521in
Width 11.65626in
Style None
Left
ZIndex
Column Count 3
  Tablix Body
Body Item Body Item Content Name Content Type Content Value
Row Cell ExpenseToPriorYearPeriodAmount Textbox =Sum(Fields!ExpenseToPriorYearPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount Textbox =IIf(IsNothing(Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) / Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query"))
Cell ExpenseToPeriodAmount Textbox =Sum(Fields!ExpenseToPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount1 Textbox =IIf(IsNothing(Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPeriodAmount.Value) / Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query"))
Cell Rectangle1 Rectangle
Row Cell Textbox43 Textbox =Sum(Fields!ExpenseToPriorYearPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount2 Textbox =IIf(IsNothing(Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) / Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query"))
Cell Textbox45 Textbox =Sum(Fields!ExpenseToPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount5 Textbox =IIf(IsNothing(Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPeriodAmount.Value) / Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query"))
Cell Rectangle3 Rectangle
Row Cell ExpenseToPriorYearPeriodAmount1 Textbox =Sum(Fields!ExpenseToPriorYearPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount4 Textbox =IIf(IsNothing(Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPriorYearPeriodAmount.Value) / Sum(Fields!ExpenseToPriorYearPeriodAmount.Value, "PercentageSpendingCurrentFY_Query"))
Cell ExpenseToPeriodAmount1 Textbox =Sum(Fields!ExpenseToPeriodAmount.Value)
Cell TotalExpensesToPeriodJournalAmount3 Textbox =IIf(IsNothing(Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query")), "", Sum(Fields!ExpenseToPeriodAmount.Value) / Sum(Fields!ExpenseToPeriodAmount.Value, "PercentageSpendingCurrentFY_Query"))
Cell Rectangle2 Rectangle
Row Cell ExpenseToPriorYearPeriodAmount2 Textbox =Sum(Fields!ExpenseToPriorYearPeriodAmount.Value)
Cell Textbox5 Textbox
Cell ExpenseToPeriodAmount2 Textbox =Sum(Fields!ExpenseToPeriodAmount.Value)
Cell Textbox11 Textbox
Cell Rectangle7 Rectangle
  Row Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Group Compensation_Category =Fields!Compensation_Category.Value
Header Textbox Compensation_Category =Fields!Compensation_Category.Value
Member Header Textbox Textbox1 Total
  Column Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Header Textbox Textbox30 Prior Year
Member Header Textbox Textbox37 Current Year , =Fields!Fiscal_Year.Value
Member Header Textbox Textbox63
Powered by BI Documenter