JavaScript
new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 600,
toolbar: true,
report: getReport()
});
function expand() {
flexmonster.expandData('Year')
}
function getReport() {
return {
dataSource: {
type: "json",
data: [
{
ScenarioKey: 1,
ScenarioName: 'Actual',
OrganizationKey: 3,
OrganizationName: 'Northeast Division',
AccountKey: 80,
AccountDescription: 'Building Leasehold',
Amount: 586,
Year: '2010',
Month: '12'
},
{
ScenarioKey: 2,
ScenarioName: 'Budget',
OrganizationKey: 3,
OrganizationName: 'Northeast Division',
AccountKey: 80,
AccountDescription: 'Building Leasehold',
Amount: 550,
Year: '2010',
Month: '12'
},
{
ScenarioKey: 2,
ScenarioName: 'Budget',
OrganizationKey: 3,
OrganizationName: 'Northeast Division',
AccountKey: 81,
AccountDescription: 'Vehicles',
Amount: 380,
Year: '2010',
Month: '12'
},
{
ScenarioKey: 1,
ScenarioName: 'Actual',
OrganizationKey: 3,
OrganizationName: 'Northeast Division',
AccountKey: 81,
AccountDescription: 'Vehicles',
Amount: 363,
Year: '2010',
Month: '12'
},
{
ScenarioKey: 1,
ScenarioName: 'Actual',
OrganizationKey: 3,
OrganizationName: 'Northeast Division',
AccountKey: 82,
AccountDescription: 'Equipment',
Amount: 35,
Year: '2010',
Month: '12'
},
{
ScenarioKey: 2,
ScenarioName: 'Budget',
OrganizationKey: 3,
OrganizationName: 'Northeast Division',
AccountKey: 82,
AccountDescription: 'Equipment',
Amount: 40,
Year: '2010',
Month: '12'
},
{
ScenarioKey: 2,
ScenarioName: 'Budget',
OrganizationKey: 3,
OrganizationName: 'Northeast Division',
AccountKey: 83,
AccountDescription: 'Furniture and Fixtures',
Amount: 100,
Year: '2010',
Month: '12'
},
{
...