-
Measures
-
Week Day
Measure
=Fields!WeekDay.Value
Sum
#,##0.00;(#,##0.00)
0
-
Week Number
Measure
=Fields!WeekNumber.Value
Sum
#,##0.00;(#,##0.00)
0
-
Month
Measure
=Fields!Month.Value
Sum
#,##0.00;(#,##0.00)
0
-
Quarter
Measure
=Fields!Quarter.Value
Sum
#,##0.00;(#,##0.00)
0
-
Year
Measure
=Fields!Year.Value
Sum
#,##0.00;(#,##0.00)
0
-
Quantity
Measure
=Fields!Quantity.Value
Sum
#,##0.00;(#,##0.00)
0
-
Price
Measure
=Fields!Price.Value
Sum
#,##0.00;(#,##0.00)
0
-
Unit Cost
Measure
=Fields!UnitCost.Value
Sum
#,##0.00;(#,##0.00)
0
-
Line Value
Measure
=Fields!LineValue.Value
Sum
#,##0.00;(#,##0.00)
0
-
Line Cost
Measure
=Fields!LineCost.Value
Sum
#,##0.00;(#,##0.00)
0
-
Gross Profit%
Measure
=Fields!GrossProfit%.Value
Sum
#,##0.00;(#,##0.00)
0
-
Profit
Measure
=Fields!Profit.Value
Sum
#,##0.00;(#,##0.00)
0
Measures
-
Attributes
-
Division
Attribute
=Fields!Division.Value
=Fields!Division.Value
-
Warehouse
Attribute
=Fields!Warehouse.Value
=Fields!Warehouse.Value
-
FY Period
Attribute
=Fields!FYPeriod.Value
=Fields!FYPeriod.Value
-
Invoice Date
Attribute
=Fields!InvoiceDate.Value
=Fields!InvoiceDate.Value
-
Customer
Attribute
=Fields!Customer.Value
=Fields!Customer.Value
-
Item
Attribute
=Fields!Item.Value
=Fields!Item.Value
-
Description
Attribute
=Fields!Description.Value
=Fields!Description.Value
-
Product Range
Attribute
=Fields!ProductRange.Value
=Fields!ProductRange.Value
-
Product Group
Attribute
=Fields!ProductGroup.Value
=Fields!ProductGroup.Value
-
Group Customer
Attribute
=Fields!GroupCustomer.Value
=Fields!GroupCustomer.Value
-
Salesman
Attribute
=Fields!Salesman.Value
=Fields!Salesman.Value
-
UOM
Attribute
=Fields!UOM.Value
=Fields!UOM.Value
-
UOM Price
Attribute
=Fields!UOMPrice.Value
=Fields!UOMPrice.Value
-
Invoice No
Attribute
=Fields!InvoiceNo.Value
=Fields!InvoiceNo.Value
-
Postcode
Attribute
=Fields!Postcode.Value
=Fields!Postcode.Value
-
Territory
Attribute
=Fields!Territory.Value
=Fields!Territory.Value
-
Busisness Sector
Attribute
=Fields!BusisnessSector.Value
=Fields!BusisnessSector.Value
-
Manufacturer
Attribute
=Fields!Manufacturer.Value
=Fields!Manufacturer.Value
-
Supplier
Attribute
=Fields!Supplier.Value
=Fields!Supplier.Value
-
Location
Attribute
=Fields!Location.Value
=Fields!Location.Value
Attributes
[Attributes].[Division]
- [Measure Names]
- [Measure Values]